how do u decide whether u need to do aggregations at
database level or at Informatica level?
- 1 Answers
- 4410 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 |
Which transformation we use to convert 'NA' to 'Not Available'
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
what is the meant by Normalization and de-normalization?
What are three tier systems in etl?
What is a mapping?
Need Informatica Power Center 9.1 free download(for all windows version)
how to connect to a flatfile through ftp in informatica
how do u decide whether u need to do aggregations at database level or at Informatica level?
What do you understand by active and passive transformations?
In Which Transformation We Can Use Having Clause In Informatica?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
Teradata 
