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 / sai
There is no performance difference while aggregation because Order by always comes after Aggregation.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain in detail about scd type 1 through mapping.
Enlist the tasks for which source qualifier transformation is used.
What is the maplet?
What is informatica worklet?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explain the different kinds of facts.
What are the performance considerations when working with aggregator transformation?
Define mapplet?
can u any challenge your project?
design of staging area?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is the command used to run a batch?
How can we remove the duplicates from flat file source?
In how many ways we can create ports?