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
How many number of sessions can one group in batches?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Define sessions in informatica etl?
What is Cognos script editor?
How to do the error handling of if ur source is flatfiles?
Explain sessions?
In informatics server which files are created during the session rums?
How do you load only null records into target? Explain through mapping flow.
Enlist few areas or real-time situations where informatica is required.
server hot-ws270 is connect to Repository B. What does it mean?
What are the features of complex mapping?
What is the function of union transformation?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Difference between Target-based loading and constraint-based loading?
Performance tuning( what you did in performance tuning)