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
- 7237 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Differentiate between source qualifier and filter transformation?
What is a stored procedure transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How to create a non-reusable instance of reusable transformations?
What is sq transformation?
How can you define user defied event?
What is sequence generator transformation in informatica?
Difference between Data and Index Caches?
How you prepared reports for OLAP?
How can one identify whether mapping is correct or not without connecting session?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to load last n records of file into target table - informatica
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is the sql query overwrite in source qualifier in informatica
