How to improve the performance of Aggregate
transformation?
Answer Posted / deepthi
1.Use sorted data and enable option 'sorted i/p'
2.By using incremental aggregation
3.group by simple columns like numeric columns
4.use filter transformation before aggregator to avoid
unnecessary aggregation on unwanted columns.
Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
Explain transaction control transformation in informatica
What is decode in static cache?
Enlist the various types of transformations.
What is sq transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is a passive transformation?
What is dynamic cache?
What all are steps in up gradation of Informatica server?
Explain target update override in informatica
How can repository reports be accessed without sql or other transformations?
What is source qualifier transformation in informatica?
What is an expression transformation in informatica?
Which are the different editions of informatica powercenter that are available?
Define joiner transformation?
have u done any performance tuning? how u ll do?