Answer / swetha

The Designer automatically creates a RANKINDEX port for each
Rank transformation. The Informatica Server uses the Rank
Index port to store the ranking position for each record in
a group. For example, if you create a Rank transformation
that ranks the top 5 salespersons for each quarter, the rank
index numbers the salespeople from 1 to 5:

Answer / lalamaheshkumar

Hi for the above question you are going to get the suresh
record twice if you select rank as two (2) . to get the
distinct records , in source qualifier put a distinct
clause in the query .. then you will get the correct result.

Answer / shashi

like to add a little bit.
just go to any Query editor and use DENSE rank() this will
clarify much more.

Answer / shankar mahadevan

The Designer creates a RANKINDEX port for each Rank
transformation. The Integration Service uses the Rank Index
port to store the ranking position for each row in a group.
For example if a Rank transformation is created on the top
five salespersons for each quarter

(Matrix being Sales Person and Measure is Sales) Criterion
Top or bottom (Quarter is a time based dimension)

Answer / lalamaheshkumar

small correction for above ..

Hi for the above question you are going to get the suresh
record twice if you select rank as three (3) . to get the
distinct records , in source qualifier put a distinct
clause in the query .. then you will get the correct result.

Answer / kajal mishra

Rank port. Use to designate the column for which you want to rank values. You can designate only one Rank port in a Rank transformation. The Rank port is an input/output port.

http://tutorialcorner.com/2015/12/rank-transformation-in-informatica-with-example/

Answer / suresh

hi all
if we have two records with same data

i mean duplicate records

at that time how the is calculated for that

let me know

example

name,age

suresh,23
ramesh,25
suresh,23
murali,20

Enlist the advantages of informatica.

0 Answers  

How to Create a folder using pmrep command?

0 Answers  

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

explain abt joiner t/r?

1 Answers   IBM,

My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,

how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,

Whats the difference between $, $$, $$$

9 Answers  

what is mapping optimization? wat are the techniques for tat

2 Answers  

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

2 Answers  

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,