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

can we use cartesian join in informatica

3 Answers   IBM,

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

8.what is mapplet ?give example?

2 Answers  

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  

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,

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

Mapplets can you use an active transformation in a mapplet,

1 Answers  

Explain joiner transformation in informatica

0 Answers   Informatica,

Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,

Is there any way to read the ms excel datas directly into informatica?

0 Answers  

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

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

1 Answers   Amdocs,