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
waht type of interface is used for testing the data in informatica
What are the designer tools for creating transformations?
What is an Integration service in Informatica?
Define update strategy?
Which are the different editions of informatica powercenter that are available?
What is domain and gateway node?
Repository user profiles
What is the fact table?
Briefly define a session task?
What are active and passive transformations?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the uses of etl tools?
What is meant by incremental aggregation?
What are the differences between source qualifier and joiner transformation?