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
- 8769 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 are the different versions of informatica?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Difference between Target-based loading and constraint-based loading?
Can we create two repositories on same database instance in oracle?
What is incremental aggregation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Explain lookup transformation source types in informatica
what is SDLC way of code development?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
tell me the rules and responsblites in our project(my project is development)
What is the commit type if you have a transaction control transformation in the mapping?
What are the new features of informatica 9.x developer?
How to call shell scripts from informatica?
What are the types of caches in lookup?
What the difference is between a database, a data warehouse and a data mart?
