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
In how many ways we can create ports?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the different transaction levels available in transaction control transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the status code in stored procedure transformation?
Explain about cumulative Sum or moving sum?
What is a joiner transformation?
How to call shell scripts from informatica?
What is a dimensional model?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What are the tasks that can be performed using sq?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the use of transformation?