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
- 7229 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
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
Define update strategy?
In how many ways we can create ports?
Make a note of the quantity vaults made in informatica?
What do you mean by channel change?
What is powercenter on grid?
Is it possible to create multiple domains on a single Informatica server?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Suppose we do not group by on any ports of the aggregator what will be the output?
Why update strategy and union transformations are active?
What is blocking transformation?
Explain the features of connected and unconnected lookup.
I have a flat file, want to reverse the contents of the flat file
my source is junk data how will u remove that junk data by using unix please any one replay me
Differentiate between joiner and lookup transformation?
What are the transformations that are not supported in mapplet?
