how do u decide whether u need to do aggregations at
database level or at Informatica level?
- 1 Answers
- 3605 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
what is Forward,Reverse and Re_engineering?
what is the use of server?
how many steps are there in etl process?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
Explain different types of partitioning?
what is pmrep command?
Identifying the bottlenecks in various components of Informatica and resolving them.
Compare etl & elt?
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
when should one create lookup transformation ?
my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
Define slowly changing dimensions (SCD)?
Teradata 
