Interested to Buy Any Domain ? << Click Here >> for more details...
How to improve the performance of Aggregate
transformation?
- 3 Answers
- 14294 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
What is exclusive and normal mode for repository services?
How do you migrate data from one environment to another?
Different circumstance which drives informatica server to expel records?
What are the differences between a connected lookup and unconnected lookup?
What is the different lookup cache(s)?
What is native users?
What are the different ways to implement parallel processing in informatica?
Explain the code page compatibility?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What are the different components of powercenter?
How many ways are there to create ports?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Which transformation is needed while using the Cobol sources as source definitions?
How to go to the older version for a mapping?
What is an expression transformation?
