we hava a flat file having more than 1000 records and two
targets. i have to write first half of the rows into first
targets and next half of rows into second target. how can i
do in informetica??



we hava a flat file having more than 1000 records and two targets. i have to write first half of th..

Answer / naveen

simple, use the router transformation. when u r able to
find which is the first half and which is the second half
exactly

But how to find ?

thats the second question , the clue is we can use sorter ,
aggregator , router itself to do this job.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ETL Interview Questions

how does the server recongnise the source and target databases.Elaborate on this

1 Answers   Accenture,


How to fine tune mappings?

1 Answers  


how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1 Answers  


I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way

2 Answers  


what are the reports developed in sap bw project and what is the requirement for developing it?

1 Answers   Maersk,


How to increase performance without changing anything in mapping.( In prod)

1 Answers   IBM, Saama Tech, Wipro,


Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

1 Answers  


Explain the difference between etl tool and olap tools?

1 Answers  


What is Relational Integrity?

1 Answers  


what are the reporting tools and difference between them?

1 Answers  


Identifying the bottlenecks in various components of Informatica and resolving them.

2 Answers  


What are the types of Data Warehouse applications?

1 Answers  


Categories