Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Rankindex in Ranktransformation?
- 7 Answers
- 20758 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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:
| Is This Answer Correct ? | 12 Yes | 2 No |
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.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / shashi
like to add a little bit.
just go to any Query editor and use DENSE rank() this will
clarify much more.
| Is This Answer Correct ? | 3 Yes | 2 No |
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)
| Is This Answer Correct ? | 1 Yes | 1 No |
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.
| Is This Answer Correct ? | 1 Yes | 1 No |
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/
| Is This Answer Correct ? | 0 Yes | 0 No |
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
| Is This Answer Correct ? | 0 Yes | 3 No |
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How will you convert rows into columns or columns into rows
State the limitations where we cannot use joiner in the mapping pipeline?
What is status code?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
what is mapping parameter and mapping variables
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
Explain lookup transformation source types in informatica
Briefly describe lookup transformation?
What is a stored procedure transformation?
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
Teradata 
