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.
- 4 Answers
- 7243 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
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
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Differences between connected and unconnected lookup?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What all join we can perform in LOOKUP transformation?
Mention some types of transformation?
Where are the source flat files kept before running the session?
what are 3 tech challenges/ common issues you face?
Explain sessions and how many types of sessions are there?
What is a repository? And how to add it in an informatica client?
What is session task and command task?
What do you understand by term role-playing dimension?
What is lookup change?
What is the cumulative sum and moving sum?
What are the features of complex mapping?
