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.
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 |
To import the flat file definition into the designer where should the flat file be placed?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
Can we create two repositories on same database instance in oracle?
What is blocking transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How to jion 2 tables, without using any condition?
what is meant by data driven.. in which scenario we use that..?
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
What are the types of lookup?
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?