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 substr in informatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Explain dynamic target flat file name generation in informatica
What are the different components of powercenter?
How can we delete duplicate rows from flat files?
What are the different transaction levels available in transaction control transformation?
How we can use union transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are Dimensional table?
What differs when we choose the sorted input for aggregator transformation?
what is the size of your data warehousing?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is dimensional table? Explain the different dimensions.
What is rank transform?
4 yrs etl devloper roles and responsibilities?any body give solutions