What are the rank caches?

Question Posted / swetha

2 Answers
11889 Views
Informatica, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the rank caches?..

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

What are the rank caches?..

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

Post New Answer

More Informatica Interview Questions

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers

daily how much amount of data send to production?

4 Answers HSBC,

What are the new features of informatica 9.x at the developer level?

0 Answers

I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 Answers

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers Wipro,

After we make a folder shared can it be reversed?Why?

2 Answers Accenture,

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers Cap Gemini,

What is sequence generator transformation in informatica?

0 Answers

what is data driven in update strategy transformation?

2 Answers HCL, PayPal,

How can i send first half of the records to one target and Remaining to other target?

10 Answers TCS,

how can we load starting with 11th record of a table from source to target

6 Answers IBM,

What is log file,and where is it located,why u r using the log file

1 Answers TCS,

For more Informatica Interview Questions Click Here