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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
Separate from a database, an information bazaar, and an information stockroom?
What does role playing dimension mean?
difference between informatica 8.1.1 and 8.6
can anyone explain me about retail domain project in informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is parallel processing in informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is a predefined event?
What is the difference between a connected look up and unconnected lookup?
What is the commit type if you have a transaction control transformation in the mapping?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the databases that informatica can connect to windows?
Explain the difference between mapping parameter and mapping variable?
What are the static cache and dynamic cache in informatica?
How we can use union transformation?