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

how do u implement scheduling in Informatica?

1 Answers   Cognizant,


without using ETL tool can u prepare a Data warehousing and maintaining?

3 Answers  


What is ROWID explain ?

2 Answers   Wipro,


What is etl process. How many steps etl contains explain with example?

0 Answers  


WHY CANT WE SEE THE DATA IN DATASET

1 Answers   IBM,






how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

0 Answers  


What is tracing level? How many types of transformations supported by sorted input?

0 Answers  


when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

0 Answers  


Explain about enterprise scalability and roi of data integration suite?

0 Answers  


I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way

2 Answers  


Explain different types of partitioning?

0 Answers  


how do u set partition points in the mapping?

0 Answers  


Categories