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
Explain Dataware house architecture .how data flow from intial to end?
Differentiate between router and filter transformation?
Define the various join types of joiner transformation?
In informatics server which files are created during the session rums?
What is enterprise data warehousing?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is joiner transformation?
How can we create index after completion of load process?
How to call shell scripts from informatica?
While migrating the data from one environment to another environment how would you manage the connections?
What is difference between a gateway node and worker node?
How do you load alternate records into different tables through mapping flow?
can u give example for factless fact table
How do you change a non-reusable transformation to reusable transformation?
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