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
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are the mapping parameters and mapping variables?
What is lookup transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Which transformation is needed while using the Cobol sources as source definitions?
Explain sql transformation in script mode examples in informatica
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How can one identify whether mapping is correct or not without connecting session?
Can informatica load heterogeneous targets from heterogeneous sources?
What is aggregator transformation in informatica?
Separate from an archive server and a powerhouse?
what is informatica metadata?
What is meant by LDAP users?
Explain the code page compatibility?
How to load the data from a flat file into the target where the source flat file name changes daily?