if i have a delimited file as source so how can we seperate this file into three diff targets?

Answers were Sorted based on User's Feedback



if i have a delimited file as source so how can we seperate this file into three diff targets?..

Answer / lakshmi

using expression ,transaction control transformations

Is This Answer Correct ?    0 Yes 0 No

if i have a delimited file as source so how can we seperate this file into three diff targets?..

Answer / guest

Try with Router transformation.

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

why we use informatica in our project?

2 Answers   TCS,


Explain about perform recovery?

1 Answers  


Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers  


Under what condition selecting sorted input in aggregator may fail the session?

0 Answers  


If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  






What is the use of incremental aggregation?

2 Answers  


How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  


Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  


Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva

1 Answers   Accenture,


How to join three sources using joiner? Explain though mapping flow.

0 Answers  


What is a command that used to run a batch?

4 Answers  


Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  


Categories