3. Suppose Seq Gen is supplying a increamental value to a column
of a table, suppose, table's column value reaches to maximum
value, then what will happen, will the session fail? If it is the
situation, then what should be done so that we can stop this kind
of situation in advance?

Answer Posted / itsranjan

In properties window of sequence generator one can select
reset or cycle option to avoid such kind of situations.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Parameter and variable differences

1705


hi real timers . iam waiting for ur reply regarding ETL TESTING

1909


What is the commit type if you have a transaction control transformation in the mapping?

737


Clarify the aggregator change?

689


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

690






What is a repository? And how to add it in an informatica client?

773


How are indexes created after completing the load process?

1094


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1849


Scheduling properties,whats the default (sequential)

1550


What are the guidelines to be followed while using union transformation?

742


What are the advantages of informatica?

662


Which version configuration tool used in ur project?

2864


What are the tuning techniques you applied during your last project

1661


Different qualification between a related rotate toward the sky and isolates look upward?

647


can anyone suggest best free Talend data integration training online

1348