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


Please Help Members By Posting Answers For Below Questions

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.

1849


Explain why we use partitioning the session in informatica?

611


Explain the tuning lookup transformation - informatica

611


How to create or import flat file definition in to the warehouse designer?

610


How to join three sources using joiner? Explain though mapping flow.

696






How do you load only null records into target?

742


How to go to the older version for a mapping?

602


What is dimensional table?

619


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

623


What is deployment group?

683


What is lookup change?

614


What are the transformations that are not supported in mapplet?

597


How can we use mapping variables in informatica?

597


What is workflow? What are the components of the workflow manager?

640


What are the differences between source qualifier and joiner transformation?

598