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 are active and passive transformations?
What all are steps in up gradation of Informatica server?
Partition, what happens if the specified key range is shorter and longer
Difference between Data and Index Caches?
What is the cumulative sum and moving sum?
What is the benefit of session partitioning?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How can we create index after completion of load process?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What do mean by local and global repository?
explain about unit testing? in real time?
How many transformations can be used in mapplets.
What all join we can perform in LOOKUP transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.