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

in the properties window of seq. gen you can either select
reset or cycle option to avoid the above situation...

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2131


What is the need for an etl tool?

628


Different sorts of metadata that stores in the storage facility?

546


What is a mapplet/worklet in informatica?

678


where to store informatica rejected data? How to extract the informatica rejected data?

596






How identifying bottlenecks in various components of informatica and resolving them?

575


Enlist the advantages of informatica.

622


How to create the source and target database connections in server manager?

618


In informatica workflow manager, how many repositories can be created?

772


Global and Local shortcuts. Advantages.

1458


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6388


Write the unconnected lookup syntax?

648


How we can use union transformation?

603


How to generate sequence numbers without using the sequence generator transformation?

637


What are the different types of transformation available in informatica.

626