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 the way to execute pl/sql script using informatica mapping?

1210


How to create a non-reusable instance of reusable transformations?

871


What are the mapping parameters and mapping variables?

806


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1683


Describe data concatenation?

763


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1831


What is powercenter on grid?

916


Enterprise data warehouse your projects phase by phase explain?

1655


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2124


What are the components of workflow manager?

782


What are ETL Tools?

843


What is domain in terms of informatica?

755


What is meant by target load plan?

731


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5330


What is informatica powercenter repository?

906