If source is flat file its aggregator of course but if source RDMS then we

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

Question Posted / sajj

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

963

What is meant by incremental load?

1088

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

2108

what are the concerns of OLTP and DSS systems?

2442

What is data cleaning?

937

What are the types of Data Warehouse applications?

1014

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

1952

what is data modeling?

1900

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2261

what is an ETL or ETT? And what are the different types?

7486

what is the meaning of upgradation of Repository?

3741

Explain etl?

975

Two default user groups created in the repository are____and_____.

2032

Explain do we need an etl tool? When do we go for the tools in the market?

998

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

2174