how do u decide whether u need to do aggregations at
database level or at Informatica level?
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 reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
how do u really know that paging to disk is happening while u are using a lookup transform?
What is a mapping?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what are the production issues in datastage?
Explain about hash partitioning?
Explain the use lookup tables and Aggregate tables?
what is pmrep command?
Compare etl & elt?
How to increase performance without changing anything in mapping.( In prod)
0 Answers IBM, Saama Tech, Wipro,
if i have a query as flat file how can we load data to target table
what is data modeling?