Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Rankindex in Ranktransformation?
- 7 Answers
- 21327 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 |
I have source like this 1:2;3. so i want to load the target as 123
What is mapping debugger?
In ur current projectu have done any performance tuning of mappings?
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What does role playing dimension mean?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is power play plug in?
What is difference between stored procedure transformation and external procedure transformation?
Teradata 
