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

What are junk dimensions?

0 Answers  

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,

In which scenario did you used pushdown optimization?

1 Answers  

Explain the flow of data in Iinformatica?

1 Answers  

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  

How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  

What is lookup change?

0 Answers  

What is a candidate key?

7 Answers   CTS,

My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

Can we make worklet inside worklet?

1 Answers