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
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 |
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 |
What is up date strategy and what are the options for update strategy?
Is stop and abort are same in informatica?
What is the need of etl tools?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)
What is the difference b/w natural key and surrogate key
What is dimensional table? Explain the different dimensions.
What are the types of metadata that stores in repository?
Define informatica repository?
What are the Advantages of de normalized data?