what are the limitation of sorter transformation?

Answers were Sorted based on User's Feedback

what are the limitation of sorter transformation?..

Answer / shiva

limitation is with the sortor cache. the following are its
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

what are the limitation of sorter transformation?..

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

Post New Answer

More Informatica Interview Questions

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,

What is up date strategy and what are the options for update strategy?

2 Answers  

how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   IBM, Cap Gemini,

what is degenerated dimension?

1 Answers   IBM,

What is sq transformation?

0 Answers  

How will u find weather dimension table is big in size of a fact table?

1 Answers  

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

What is the difference between a repository server and a powerhouse?

0 Answers  

What is the session task and command task?

0 Answers  

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers