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
What is session task and command task?
What the difference is between a database, a data warehouse and a data mart?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the tasks that source qualifier perform?
How do we call shell scripts from informatica?
Explain the etl program with few examples.
Can we override a native sql query within informatica?
What is dimensional table?
What is the need of an ETL tool?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is target designer and target load order?
Make a note of the quantity vaults made in informatica?
On which transformations you created partitions in your project?
Explain your project of banking domian.
What is meant by target load plan?