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
How can we create index after completion of load process?
What is the sequence generator transformation in informatica?
What is meant by active and passive transformation?
How to implement security measures using repository manager?
What is native users?
In warehouses how many schemas are there?
How can a transformation be made reusable?
Explain the aggregator transformation?
What are the different ways to implement parallel processing in informatica?
How to partition the Session?
lookup transformation with screenshots
4 yrs etl devloper roles and responsibilities?any body give solutions
How can you define user defied event?
differences between service based and product based?
State the differences between sql override and lookup override?