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
- 4269 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 is the difference between cardinality and Nullability?
how do u extract data from different data sources explain with an example?
Two default user groups created in the repository are____and_____.
how do u really know that paging to disk is happening while u are using a lookup transform?
can be used COM component in Informatica ?
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.
how does the server recongnise the source and target databases.Elaborate on this
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 session partitioning?
what are the facilities provided by data warehouse to analytical users?
How can we use external procedural logic in informatica?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What are your responsibilities as an etl tester?
explain the methodology of Data Warehousing?(Polaries)
