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 / shridhar
We can use one more sequence generator after that sequence
generator or get the value of max key in unconnected lookup
tx and call that value in expression tx and add +1 to the
value and send to the next tx.
Thanks
Shridhar
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is decode in static cache?
Explain the mapping variable usage example in informatica
How to update source definition?
What does command task mean?
What is the difference between informatics 7x and 8x and what is latest version?
explain about unit testing? in real time?
Briefly define reusable transformation?
What are the different types of repositories created using informatica?
Explain pushdown optimization and types in informatica
Whats there in global repository
How to update a particular record in target with out running whole workflow?
Differentiate between sessions and batches?
How can repository reports be accessed without sql or other transformations?
How to use procedural logic inside infromatica?
Differentiate between router and filter transformation?