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 / bharath yadav
after sorting data in sorter tf enable sorted input in aggregator tf for better performance . if the sorted data key in sorter tf and aggregator tf differs then session fails.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Target increases every day even though no new record was inserted
What are the designer tools for creating transformations?
How can you generate reports in informatica?
What is source qualifier transformation in informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What happens when a session fails and you click on recover?
Explain lookup transformation source types in informatica
What is DR strategy for Informatica project?
Define mapping and session?
Why is sorter an active transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
wat are deployement groups in informatica, how it will be used for developers
What is meant by query override?
Explain incremental aggregation in informatica
What is standalone command task?