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 / gyana
source--->sq--->attached a sequence generator with settings
current value=1
start value=1
end value=3
incrimented by=1
cycle=yes
------->router(3groups)--->3 targets
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is meant by query override?
What is the use of code page?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are the modules in Power Center
What are the limitations of joiner transformation?
What is update strategy transform?
What is a connected transformation?
Define enterprise data warehousing?
How do you load unique records into one target table and duplicate records into a different target table?
What are the different clients of powercenter?
How do you convert single row from source into three rows into target?
Write the unconnected lookup syntax and how to return more than one column.
what is Active lock explain
How would you copy the content of one repository to another repository?
How to update or delete the rows in a target, which do not have key fields?