i have flat file it contains 'n' number of records, i need
to send half of the records to one target table and
Remaining half to another target table.
can any tell me procedure.

Answer Posted / mari ilavarasi

Using router transformation we can send half of the records
in one target and rest of the records will be inserted into
another target based on conditions.

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is domain and gateway node?

948


Can we create multiple integration service on single repository?

978


What is joiner change?

937


if we have a delimiters at unwanted places in a flat file how can we over come those.

1836


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2111


How many dimensions are there in informatica?

853


What do you mean by blocking transformation?

803


What is blocking transformation?

931


Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1665


What is source qualifier transformation in informatica?

771


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1748


Under what conditions selecting sorted input in aggregator will still not boost session performance?

858


can we override a native sql query within informatica? Where do we do it?

898


What is a code page?

939


What's the layout of parameter file (what does a parameter file contain?)?

2203