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
- 8761 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / sai
There is no performance difference while aggregation because Order by always comes after Aggregation.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How can you differentiate between powercenter and power map?
What are the modules in Power Center
How can we use batches?
Describe data concatenation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain pushdown optimization and types in informatica
How identifying bottlenecks in various components of informatica and resolving them?
What is dynamic cache?
What is meant by LDAP users?
What are active and passive transformations?
How to update or delete the rows in a target, which do not have key fields?
How can one identify whether mapping is correct or not without connecting session?
tell me the rules and responsblites in our project(my project is development)
What is a filter transformation and why it is an active one?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
