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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kns
source--->source qualifier-->sequence gen(we want to
reset)--->expression(decode)---->router(conditions)--->targets
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / cool buddy
take the rank T/R(take no.of ranks=4)and the take router t/r
in that give conditions as 1)rankindex=1,2)rkindx=2 etc.,
i think this will do .
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / sushma
Source ---> SQ ---> Expression ---> Router ---> Targets
Is This Answer Correct ? | 3 Yes | 4 No |
what is lookup chache?
What is a taget load order?
what is bitmap index? did u use it?and how to use it in informatica
What is informatica? Why do we need it?
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
In operator is used in which transformation in informatica 8.6.0
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
What is aggregate cache in aggregator transformation?
 Code page compatibly –Where all changes are made to handle the scenario.
What is the need of an ETL tool?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,