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
- 4212 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
Two default user groups created in the repository are____and_____.
What are materialized views & where do we use them?
What is tracing level and what are the types?
What is partitioning? Explain different types of partitioning?
what is the use of server?
explain the methodology of Data Warehousing?(Polaries)
How many steps etl contains explain with example?
Explain etl mapping sheets?
What is full load & incremental or refresh load?
What are the different Lookup methods used in Informatica?
what are the session parameters? How do u set them?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
what is the meaning of upgradation of Repository?
how many maximum session supports to multiload in teradata ??
What is fact? What are the types of facts?
