Interested to Buy Any Domain ? << Click Here >> for more details...
what are the limitation of sorter transformation?
- 2 Answers
- 12995 Views
- TCS, I also Faced
- E-Mail Answers
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
How many number of sessions can one group in batches?
Explain scd type 3 through mapping.
How to update or delete the rows in a target, which do not have key fields?
Reusable transformation and shortcut differences
how we can load rejected record's at run time?(not through bad files)
Different qualification between a related rotate toward the sky and isolates look upward?
What do you understand by term role-playing dimension?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Write the unconnected lookup syntax?
What are pre and post-session shell commands?
What is a shortcut and copy in Informatica and how two are different with each other?
What are the restrictions of union transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to generate sequence numbers without using the sequence generator transformation?
