What are the rank caches?

Question Posted / swetha

2 Answers
11602 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

Why use the lookup transformation ?

2 Answers Informatica,

Useful UNIX commands regular/frequently used

1 Answers Deloitte,

what is the mechanism of the Master-Detail joining condition?

6 Answers IBM, Patni,

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers HCL,

In Which scenario did u used Incremental loading?

2 Answers

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers HP,

How can we eliminate duplicate rows from flatfile,explain?

3 Answers

What is the procedure to load the fact table.Give in detail?

1 Answers

What are conformed dimensions?

1 Answers

What is a command that used to run a batch?

2 Answers

can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers Amdocs,

For more Informatica Interview Questions Click Here