Interested to Buy Any Domain ? << Click Here >> for more details...
How to improve the performance of Aggregate
transformation?
- 3 Answers
- 14307 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
How many numbers of sessions can one group in batches?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Can anyone tell me the new features in Informatica 9 Version?
Why sorter is an active transformation?
Explain the code page compatibility?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What do you mean by blocking transformation?
Difference between Target-based loading and constraint-based loading?
Explain sessions. Explain how batches are used to combine executions?
How to do unit testing in informatica? How to load data in informatica ?
Clarify the utilization of aggregator cache record?
What is transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What happens when a session fails and you click on recover?
