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

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  

what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,

Why union transformation is an active transformation?

0 Answers   Informatica,

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh

4 Answers   TCS, Accenture,

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

0 Answers