Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8846 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harish
No performance downfall. Example: if your choosing sort order on deptno asc/desc and sal desc.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sai
There is no performance difference while aggregation because Order by always comes after Aggregation.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / 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 |
Answer / me
If you use sorted input and do not sort data correctly, the session fails.
| Is This Answer Correct ? | 0 Yes | 2 No |
Can you create a flatfile target
explain about lookup t/r?
what is surrogate id ?
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
What are the tuning techniques you applied during your last project
what is casual dimension?
Clarify the aggregator change?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
How do you update the records with or without using update strategy?
What are the out put files that the informatica server creates during the session running?
What is data movement mode in Informatica and difference between them?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
Teradata 
