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
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is flashback table ? Advance thanks
What is transformation?
What do you mean by enterprise data warehousing?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How does the aggregator transformation handle null values?
What is the surrogate key?
Reusable transformation and shortcut differences
Enlist few areas or real-time situations where informatica is required.
What is an expression transformation?
What is informatica metadata and where is it stored?
What is the need of etl tools?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is the Rank index port in Rank transformation?