One source and 3 targets
1st row-1st target
2nd row-2nd target
3rd row-3rd target
4th row-1ist target how will u do?
Answer Posted / usha
By using Sequence Generator transformation.
in Sequence Generator transformation we shoud set
start value =1
cycle should enable
end value = 3
increment value=1
in router we should give condion as
next value=1 for 1st group
next value=2 for 2nd group
next value=3 for 3rd group
S-->SQ--> seq-->rout--> Target1
Target2--> Target3
Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
Explain dynamic target flat file name generation in informatica
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is rank index in rank transformation?
What is intricate mapping?
What is deployment group?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Explain the different lookup methods used in informatica?
COM components can be used in Informatica
Is stop and abort are same in informatica?
How to Create a folder using pmrep command?
Explain the code page compatibility?
Differentiate between Load Manager and DTM?
What are the differences between a connected lookup and unconnected lookup?