how do u decide whether u need to do aggregations at
database level or at Informatica level?
Answer Posted / chintan thakkar
It should always be done at SQ level, that will improve the performance of the mapping since informatica stores a cache for aggregator transformation.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
How to increase performance without changing anything in mapping.( In prod)
What is lookup table in etl testing?
What are the types of Data Warehouse applications?
What are the different etl testing categories as per their function?
Give the benefits of data integration suite?
What are the ETL Testing Operations?
how do u implement configuration management in Informatica?
what is the meaning of upgradation of Repository?
Explain about round-robi?
Explain etl mapping sheets?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
What are your responsibilities as an etl tester?