Interested to Buy Any Domain ? << Click Here >> for more details...
How to improve the performance of Aggregate
transformation?
- 3 Answers
- 14445 Views
- Dmss, I also Faced
- E-Mail Answers
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
On which transformations you created partitions in your project?
How to load the data from people soft hrm to people soft erm using informatica?
Name the different lookup cache(s)?
How to use pmcmd utility command?
Explain pushdown optimization $pushdownconfig parameter - informatica
Explain in detail scd type 2 through mapping.
How can a transformation be made reusable?
How to configure mapping in informatica?
What is the need for an etl tool?
scenario where i can use only concurrent execution of workflow.
What is the status code in stored procedure transformation?
What are the popular informatica products?
Define sessions in informatica etl?
How do you promote a non-reusable transformation to reusable transformation?
Separate from an archive server and a powerhouse?
