what are the limitation of sorter transformation?
Answers were Sorted based on User's Feedback
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|
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|
If u r using dynamic cache lookup port will be thier in thet which option u will select
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
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
what are the limitations of pushdown optimization technique ? Advance thanks
Why union transformation is an active transformation?
In a concurrent batch if a session fails, can you start again from that session
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
what is meant by lookup caches?
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
we r using aggregator with out using groupby?
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?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?