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 three tier systems in etl?

0 Answers  


what are Lookup caches options? Including persistent caches.

1 Answers  


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

0 Answers  


how do u set partition points in the mapping?

0 Answers  


What do you understand by active and passive transformations?

0 Answers  


what is the difference steps for data modeling?

0 Answers  


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

0 Answers  


How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

0 Answers   IBM, Saama Tech, Wipro,


Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

5 Answers  


What is meant by incremental load?

0 Answers  


Eliminating of duplicate records without using dynamic lookups

4 Answers   IBM,


how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

0 Answers  


Categories