I have a scenario like - how can i load 1st record to
Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to
repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
Answer Posted / susanta
Take a sequence generator with Start Value=1,Current
Value=1,End Value=3, Increment By=1 to assign a seqno to
each row. Do not forget to enable the cycle option.
after that take a Router with three groups of
seqno=1,seqno=2 and seqno=3.
Hope this will help u
| Is This Answer Correct ? | 28 Yes | 1 No |
Post New Answer View All Answers
What is meant by query override?
What does update strategy mean, and what are the different option of it?
What are multi-group transformations?
How to update source definition?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How many numbers of sessions can one group in batches?
What are the modules in Power Center
What is a filter transformation?
explain abt ur project architecture?
What is intricate mapping?
Clarify the aggregator change?
explan ur project architecture?
What is target designer and target load order?
What is the difference between informatics 7x and 8x and what is latest version?
What does cheating measurement mean?