Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Rankindex in Ranktransformation?
- 7 Answers
- 21115 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 |
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
Sequence generator, when you move from develoment to production how will you reset
how to delete duplicate records by using filter transfermation?
What is rank index in rank transformation?
What is the default source option for update stratgey transformation?
How informatica recognizes mapping?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
What is the Router transformation?
In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
what is degenerated dimension
How union transformation is used?
Teradata 
