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 is different between sequential batch and concurrent batch and which is recommended and why?
what is an ETL or ETT? And what are the different types?
What are cubes and olap cubes?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What are the differences between sql override and update override?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
what are the data modeling tools you have used?(polaris)
What is staging area referring to?
how to connect to a flatfile through ftp in informatica
What is meant by incremental load?
What is a materialized view log?
What is initial load and what is full load?
where is the cache (lookup, index) created and how can you see it.
what is pmrep command?