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
- 8640 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
wat are deployement groups in informatica, how it will be used for developers
What is informatica powercenter repository?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain the difference between a data warehouse and a data mart?
Is it possible to use a client with different version than that of its Informatica server?
What is sequence generator transformation in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
how to load rows into fact table in data warehouse
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Why do we need informatica?
lookup transformation with screenshots
What is substr in informatica?
What could be the possible resons of locks by user?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
