we have 6 records in source , i need 2nd record in one
target and 5th record in one target or 2nd & 5th record in
same target.
Answer Posted / lvpr
Use two pipe lines...first pipeline add sequence gen t/r
and send data to dummy target...
In second pipeline take first pipe line's target as source
as we have seq numbers for each row now route 2 and 5 row
to diff target's or to same target
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the way to execute pl/sql script using informatica mapping?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Write the advantages of partitioning a session?
What are the various types of transformation?
How to do unit testing in informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
how to load dimension table and fact table. plz tell me the steps.
What is the use of an aggregator cache file?
What is the command used to run a batch?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How to create the source and target database connections in server manager?
What are junk dimensions?
Difference between Data and Index Caches?
Explain about Informatica server process that how it works relates to mapping variables?
What is informatica powercenter repository?