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


Please Help Members By Posting Answers For Below Questions

Why sorter is an active transformation?

740


What is a snowflake schema?

560


Explain pushdown optimization $pushdownconfig parameter - informatica

691


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

595


What is the function of look up transformation?

639






How do you load first and last records into target table?

653


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

1689


how to load dimension table and fact table. plz tell me the steps.

1675


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1765


What are the performance considerations when working with aggregator transformation?

667


What do mean by local and global repository?

689


How to convert multiple rows to single row (multiple columns) in informatica

884


Did u used latest transformations of 8.6.0? for what?

1469


What is meant by target load plan?

546


hi real timers . iam waiting for ur reply regarding ETL TESTING

1792