what are the limitation of sorter transformation?
Answer Posted / 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 |
Post New Answer View All Answers
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Explain why we use partitioning the session in informatica?
Explain the tuning lookup transformation - informatica
How to create or import flat file definition in to the warehouse designer?
How to join three sources using joiner? Explain though mapping flow.
How do you load only null records into target?
How to go to the older version for a mapping?
What is dimensional table?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is deployment group?
What is lookup change?
What are the transformations that are not supported in mapplet?
How can we use mapping variables in informatica?
What is workflow? What are the components of the workflow manager?
What are the differences between source qualifier and joiner transformation?