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
How to join three sources using joiner?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is a repository? And how to add it in an informatica client?
wf dont have integration severances how you can run?
As union transformation gives UNION ALL output, how you will get the UNION output?
Define update strategy?
What will be the approach?
What is domain in terms of informatica?
Enlist some properties of sessions.
How do you handle two sessions in Informatica
How can we delete duplicate rows from flat files?
What is incremental aggregation?
What is union transformation?
How do you convert single row from source into three rows into target?