suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?

Answer Posted / sanjay

By using the Router transformation we can load half of the
record in target 1 and half in target2.

src-->source qual--->Seq Generator(If
needed)--->router--->targets

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a surrogate key?

555


How are the sources and targets definitions imported in informatica designer?

666


What are the different types of olap? Give an example?

554


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1617


In informatica workflow manager, how many repositories can be created?

776






What is target load order?

803


What do you understand by term role-playing dimension?

566


What is aggregate cache in aggregator transformation?

627


What is primary and backup node?

692


where to store informatica rejected data?

672


What is aggregator transformation in informatica?

539


Quickly characterize reusable change?

685


Why filter transformation is an active one?

559


Mention some types of transformation?

602


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

596