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 / manthiramoorthy. g
S-SQ-EXP-SEQ-RTR-Tgt1,Tgt2,Tgt3
In Router: (Group Condition)
MOD(nextval,3)=0 Connect To Tgt1
MOD(nextval,3)=1 Connect To Tgt2
MOD(nextval,3)=2 Connect To Tgt3
Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
What is source qualifier transformation in informatica?
What do you mean by blocking transformation?
How can you increase the performance in joiner transformation?
What are the tasks that can be performed using sq?
How to update source definition?
Parameter and variable differences
How to open an older version of an object in the workspace?
How to configure mapping in informatica?
What is data movement mode in Informatica and difference between them?
have u done any performance tuning? how u ll do?
Design a mapping to load the cumulative sum of salaries of employees into target table?
can we override a native sql query within informatica? Where do we do it? How do we do it?
If informatica has its scheduler why using third party scheduler?
Mention a few design and development best practices for informatica?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com