What r the rank caches?

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.

  • Interview Candidate
  • 3
  • 5601

Showing Answers 1 - 3 of 3 Answers

venkat2ram

  • Apr 11th, 2014
 


Rank caches are the caches created to calculate the rank while session run for Rank transformation.

Index cache and Data cache

Index cache stores the values of the key column i.e. rank port here.
Data cache stores all other columns

Infomatica will compare the value of rank port in newly coming record with the existing data in index cache. and calculates the rank.

The link between Index cache and data cahce will be maintained.

Index cache is used to decrease the size of data on which the comparisons are done.

Thanks.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions