How could we generate the sequence of key values without
using sequence generator transformation in the target ??
Answer Posted / arnab
either use oracle to generate the sequence number or use an
unconnected lkp transformation which looks up on the
target, get the max(value) of the column which has to be
incremented and increment the value by 1
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the difference between writing a joiner query in ANSI style and THETA style?
What are the transformations that are not supported in mapplet?
According to his methodology what all you need before you build a datawarehouse
What is the surrogate key?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How many ways a relational source definition can be updated and what are they?
What are junk dimensions?
What are the tasks that can be performed using sq?
Why do we need informatica?
What do you mean by blocking transformation?
What are mapplets? How is it different from a Reusable Transformation?
Why filter transformation is an active one?
Which transformation is needed while using the Cobol sources as source definitions?
How to load last n records of file into target table - informatica
Under what condition selecting sorted input in aggregator may fail the session?