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
Why sorter is an active transformation?
What is a snowflake schema?
Explain pushdown optimization $pushdownconfig parameter - informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the function of look up transformation?
How do you load first and last records into target table?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
how to load dimension table and fact table. plz tell me the steps.
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the performance considerations when working with aggregator transformation?
What do mean by local and global repository?
How to convert multiple rows to single row (multiple columns) in informatica
Did u used latest transformations of 8.6.0? for what?
What is meant by target load plan?
hi real timers . iam waiting for ur reply regarding ETL TESTING