I HAVE 10 records in source. I want to store i record in
target 1, second record in target 2, third record in target
3, 4 th record again in target 11, 5th again in target 2,
6th again in target3 etc.... how it is possible?
Answer Posted / rucha
i will use a sequence generator to get the row number then
input this sequence numbers to an expression transformation
where i will give an if condition (row number mod 3) then
the result be stored in a variable port say x.this variable
port value is filtered using router transformation as rows
with x=1 in group1,x=2 in group 2 and x=3 in default. the
resultant groups are connected to the targets 1,2 and 3
respectively
Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What are the different lookup cache(s)?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Explain the types of lookup transformation?
What are the data movement modes in informatica?
What does command task mean?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain the code page compatibility?
explain one complex mapping with logic? sales project?
What is domain and gateway node?
What is a node in Informatica?
Parameter and variable differences
How to do unit testing in informatica?
Explain load alternative records / rows into multiple targets - informatica
What is a code page?
How to go to the older version for a mapping?