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
What is a repository? And how to add it in an informatica client?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the benefit of partitioning a session?
How to Create a folder using pmrep command?
What are multi-group transformations?
What is target designer and target load order?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is a pre-defined event and user-defined event?
How do you take back up of repository?
What is the use of transformation?
How do you change a non-reusable transformation to reusable transformation?
How to elaborate powercenter integration service?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What are the differences between joiner transformation and source qualifier transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?