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 will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is Session and Batches?
What is expression transformation?
What is main use of mapplet?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is aggregator transformation in informatica?
Differentiate between a repository server and a powerhouse?
I have a flat file, want to reverse the contents of the flat file
What is a filter transformation and why it is an active one?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is informatica worklet?
How to join three sources using joiner? Explain though mapping flow.
What is sequence generator transformation in informatica?
can you please explain me pre session and post session options?