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
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
expain about the tune parameters?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How can we update a record in the target table without using update strategy?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What do you mean by filter transformation?
Describe expression transformation?
Enlist the differences between database and data warehouse.
differences between service based and product based?
What is domain and gateway node?
What is the format of informatica objects in a repository?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
what is the Default Source Option For Update Strategy Transformation?
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. ?
Explain the scenario which compels informatica server to reject files?