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

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

Question Posted / jakki

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

More ETL Interview Questions

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

What are the various tools used in etl?

where is the cache (lookup, index) created and how can you see it.

what is the difference between cubes and package in cognos

in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?

What are the different Lookup methods used in Informatica?

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

what are the data modeling tools you have used?(polaris)

Explain me ETL project architecture in Detail?

What are various etl tools in the market?

What is a mapping?

what is the meant by Normalization and de-normalization?

For more ETL Interview Questions Click Here