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

what is informatica metadata?

609


What is aggregate cache in aggregator transformation?

643


How many ways are there to do 'remove duplicate records in informatica'?

593


What do you mean by enterprise data warehousing?

663


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1851






How to do unit testing in informatica?

735


Briefly define a session task?

599


What is the function of aggregator transformation?

589


As union transformation gives UNION ALL output, how you will get the UNION output?

655


What is a sorter transformation?

675


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1562


Explain the tuning lookup transformation - informatica

621


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

558


Why sorter is an active transformation?

758


What is a joiner transformation and why it is an active one?

584