Interested to Buy Any Domain ? << Click Here >> for more details...
how do u decide whether u need to do aggregations at
database level or at Informatica level?
- 1 Answers
- 4300 Views
- I also Faced
- E-Mail Answers
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 snapshots? What are materialized views & where do we use them? What is a materialized view log?
What are three tier systems in etl?
What are your responsibilities as an etl tester?
how do u implement configuration management in Informatica?
What are the different Lookup methods used in Informatica?
What is a lookup table in etl?
What is a mapping, session, worklet, workflow, mapplet?
what is the main role of FI on business
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
What is grain of fact?
how many steps are there in etl process?
how do use session mapping parameters ?(in which transformation)
Explain and compare etl & manual development?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
what happens if the info.server doesn't find the session parameter in the parameter file?
