what are the limitation of sorter transformation?
- 2 Answers
- 11897 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shiva
limitation is with the sortor cache. the following are its
limitations....
In version 8 it is set to Auto. In version v7 it is 8MB
If it cannot allocate then the session will fail
If it needs more memory that it will pages the data in the
Work Directory, and writes a warning in the log file.
let me know to what extent the answer is correct..
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rayudu
the limitation of sorter t/r is cache
in informatica 8 it is default auto...
| Is This Answer Correct ? | 0 Yes | 0 No |
Can anyone please distinguish what is Inner join and Outer join
What are different types of transformations available in informatica?
What are the prerequisite tasks to achieve the session partition?
what is fact and what types of fact tables is there
How do you set a varible in incremental aggregation
How can i set break points in debugging mode ? can explain steps please?
How to extract sap data using informatica? What is abap? What are idocs?
Differentiate between Load Manager and DTM?
Explain constraint based loading in informatica
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
What is session task and command task?
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
Teradata 
