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 parallel processing in informatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How can we update a record in the target table without using update strategy?
how tokens will generate?
can anyone suggest best free Talend data integration training online
Define the various join types of joiner transformation?
When do you use sql override in a lookup transformation?
Sequence generator, when you move from develoment to production how will you reset
Explain the use of aggregator cache file?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
how to load rows into fact table in data warehouse
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is joiner change?
Explain sql transformation in script mode examples in informatica
How identifying bottlenecks in various components of informatica and resolving them?