how do u decide whether u need to do aggregations at
database level or at Informatica level?



how do u decide whether u need to do aggregations at database level or at Informatica level?..

Answer / sajj

If source is flat file its aggregator of course but if source RDMS then we preferred to do it database level if possible

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ETL Interview Questions

what are the types in error loging?

0 Answers   Cap Gemini,


how do u automate Extraction process?

1 Answers  


What is lookup table in etl testing?

0 Answers  


if u can't find what you are looking for in lookup table, how do you handle?

1 Answers  


What are the names of the layers in etl?

0 Answers  


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

0 Answers  


Two different admin users created for repository are________and_________.

1 Answers  


what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

0 Answers   Accenture,


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

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  


what are the facilities provided by data warehouse to analytical users?

0 Answers  


what are Lookup caches options? Including persistent caches.

1 Answers  


Categories