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
- 4209 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 are the facilities provided by data warehouse to analytical users?
how do u really know that paging to disk is happening while u are using a lookup transform?
What are dimensions?
what are the session parameters? How do u set them?
How etl testing is different from database testing?
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
What are the names of the layers in etl?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Difference between flat files and relational sources?
what is pmrep command?
What are materialized views & where do we use them?
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
Teradata 
