how do u really know that paging to disk is happening while
u are using a lookup transform?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ETL Interview Questions

how do u set partition points in the mapping?

0 Answers  


what is the difference steps for data modeling?

0 Answers  


Explain what are the various etl tools in the market?

0 Answers  


What is factless fact schema?

3 Answers  


1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

0 Answers  






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

0 Answers  


you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.

3 Answers  


if i have a query as flat file how can we load data to target table

0 Answers   Tech Mahindra,


Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?

2 Answers  


What is cube grouping?

0 Answers  


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

0 Answers  


Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

0 Answers  


Categories