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
How can we improve session performance in aggregator transformation?
What are the static cache and dynamic cache in informatica?
Differences between version 7.x and 8.x.
What do think which one is the better joiner or look up?
What is a filter transformation and why it is an active one?
Where can we find the throughput option in informatica?
What is workflow? What are the components of workflow manager?
What are the uses of etl tools?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
explain one complex mapping with logic? sales project?
Differentiate between sessions and batches?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is informatica worklet?
How can we update a record in the target table without using update strategy?
What does “tail –f” command do and what is its use as an Informatica admin.