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

WHY CANT WE SEE THE DATA IN DATASET

1 Answers   IBM,


SCD2 will work on only dimension tables as well as fact Table?

0 Answers   Infosys,


When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.

3 Answers  


Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

0 Answers  


State the differences between shortcut and reusable transformation

0 Answers  






Do we need an etl tool?

0 Answers  


how would u estimate the size of Lookup transform data and index cache?

0 Answers  


what is granularity in Data ware House?

0 Answers   IBM,


what is the difference between cardinality and Nullability?

0 Answers  


What is cube grouping?

0 Answers  


how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com

2 Answers   TCS,


What is ROWID explain ?

2 Answers   Wipro,


Categories