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

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

0 Answers  


Explain different types of partitioning?

0 Answers  


Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you 

0 Answers  


What is ROWID explain ?

2 Answers   Wipro,


Can u access a repository created in previous version of Informatica?

1 Answers  






Which type or t/s is used to convert rows into column & column into rows

9 Answers   Infosys,


what is the difference between normal & bulk loading? and which one is recommended ? why?

2 Answers  


what is data modeling?

0 Answers  


how to load the data to fact table?

0 Answers  


How to Check the source record count from traget table.

5 Answers   IBM,


how to connect to a flatfile through ftp in informatica

1 Answers   TCS,


Can there be sub steps of etl steps?

0 Answers  


Categories