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
- 8818 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a snowflake schema?
generate date / time dimension in informatica
Explain what are the different types of transformation available in informatica.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How can a transformation be made reusable?
What are the different components of powercenter?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How to create or import flat file definition in to the warehouse designer?
What does command task mean?
What is a surrogate key?
What is a node in Informatica?
Difference between Target-based loading and constraint-based loading?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Where are the source flat files kept before running the session?
What is workflow? What are the components of workflow manager?
