What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall?
Please answer below. thank you.
Answer Posted / harish
No performance downfall. Example: if your choosing sort order on deptno asc/desc and sal desc.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Which development components of informatica have the highest usage?
How do you load only null records into target?
What are active transformations.
What are the main issues while working with flat files as source and as targets ?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is sequence generator transformation in informatica?
How to update a particular record in target with out running whole workflow?
What is different between the data warehouse and data mart?
What are the popular informatica products?
What are the types of lookup transformation?
What is the difference between a connected look up and unconnected lookup?
What is the need of an ETL tool?
Could you explain what is enterprise data warehouse?
what is the hint? how to use it to reduce the query processing in program?
Explain pushdown optimization and types in informatica