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
What is the use of code page?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is the function of aggregator transformation?
How we can create indexes after completing the load process?
Quickly characterize reusable change?
What are the modules in Power Center
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is a filter transformation?
What is different between the data warehouse and data mart?
How to create or import flat file definition in to the warehouse designer?
How to create the source and target database connections in server manager?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?