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 |
what are the different types of transformation available in informatica and what are the mostly used ?
Is it possible to update the target table with PK?
how many ways can we implement SCD2?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
When the informatica server marks that a batch is failed?
Types of error logs in Informatica?
How to use pmcmd utility command?
What is a rank transform?
How to open an older version of an object in the workspace?
What is a unit Testing?
How/where can i install Informatica software with oracle or teradata as database