What are the rank caches?
Answers were Sorted based on User's Feedback
Answer / swetha
During the session ,the informatica server compares an inout
row with rows in the datacache. If the input row out-ranks a
stored row, the informatica server replaces the stored row
with the input row. The informatica server stores group
information in an index cache and row data in a data cache.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / shashiall
Swetha answer is correct.Expanding little bit with example.
If there r 3 same salaries..Rank will eliminate the
sequences..try this...rank will come 1,2,3,3,3,6..
To confirm this go to the SQL editor and check this with
Dense rank()function.
Is This Answer Correct ? | 2 Yes | 0 No |
Define filter transformation?
What is synonym?
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
What is an unconnected transformation?
What are the different types of repositories created using informatica?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Explain lookup transformation is active in informatica
What all are steps in up gradation of Informatica server?
replace multiple spaces with single space.
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
what is the look up transformation?