Interested to Buy Any Domain ? << Click Here >> for more details...
How could we generate the sequence of key values without
using sequence generator transformation in the target ??
- 12 Answers
- 38276 Views
- TCS, Tech Mahindra, I also Faced
- E-Mail Answers
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
Differentiate between reusable transformation and mapplet.
which one is better performance wise joiner or look up
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Implementation methodology
What do think which one is the better joiner or look up?
State the limitations where we cannot use joiner in the mapping pipeline?
Can we get 1st record through Informatica(without sequence number).
Explain sql transformation in script mode examples in informatica
What is the function of union transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
without table how to come first record only in oracle?
Explain direct and indirect flat file loading (source file type) - informatica
Explain the features of connected and unconnected lookup.
How many numbers of sessions can one group in batches?
What are the different transaction levels available in transaction control transformation?
