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 / vijaykumar

Session will not fail if it reaches the maximum default
value. The Integration Services Automatically reset the
value and it's start from 1.

Is This Answer Correct ?    2 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain Dataware house architecture .how data flow from intial to end?

2209


Differentiate between router and filter transformation?

694


Define the various join types of joiner transformation?

646


In informatics server which files are created during the session rums?

730


What is enterprise data warehousing?

694






Which means the first record should come as last record and last record should come as first record and load into the target file?

695


What is joiner transformation?

660


How can we create index after completion of load process?

687


How to call shell scripts from informatica?

662


While migrating the data from one environment to another environment how would you manage the connections?

723


What is difference between a gateway node and worker node?

734


How do you load alternate records into different tables through mapping flow?

1420


can u give example for factless fact table

5735


How do you change a non-reusable transformation to reusable transformation?

690


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1776