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 use of transformation?
How to do unit testing in informatica? How to load data in informatica ?
How many numbers of sessions can one group in batches?
Can you use flat files in Mapplets.
What is rank transform?
How do you handle two sessions in Informatica
What is parallel processing in informatica?
How can we store previous session logs?
How to do unit testing in informatica?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Differentiate between Load Manager and DTM?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Explain the tuning lookup transformation - informatica
What is a dimensional model?