What are the rank caches?

Question Posted / swetha

2 Answers
11659 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 one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers Cap Gemini, IBM,

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers

Can any one explain or sujjest some sites for scd mappings.Thank you

1 Answers Wipro,

how to call lookup qualifer in unconnected look;up

1 Answers BirlaSoft,

which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers IBM,

What is the difference between a shortcut of an object and copy of an object? Compare them.

3 Answers

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers

what is the size of u r source(like file or table)?

0 Answers HP,

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers HCL,

What is expression transformation?

0 Answers

Hey I am net to informatica? Can any one explain me step by step How scd will work ?

1 Answers Infosys,

Can you copy the session to a different folder or repository?

2 Answers

For more Informatica Interview Questions Click Here