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
Explain how to import oracle sequence into informatica?
On which transformations you created partitions in your project?
Describe an informatica powercenter?
How can we update a record in the target table without using update strategy?
What are the tasks that can be performed using sq?
What are the modules in Power Center
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the need of an ETL tool?
What are the popular informatica products?
What does update strategy mean, and what are the different option of it?
Can we override a native sql query within informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What are mapplets?
What is depict expression change?
Design a mapping to load the cumulative sum of salaries of employees into target table?