how to implement dense rank in rank transformation in
Informatica? so that output should be like 1,1,2,3 and not
like 1,2,3,4
Answer Posted / balakrishna
1) Data should be sorted in the order we are expecting the
ranks to be
2)At expression level manipulating variable using the
iteration logic to generate the ranks comparing the current
record with the previous record
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Explain entity set?
Should I store images in database?
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
Explain entity type?
How to do Data integrity testing? Who does this testing (Developer or tester)?
What are different types of joins used in?
Differentiate between delete and truncate table?
Why merge statement is used inside the database?
how do you do sql tuning?
What is the use of graph database?
What is a Database?
Under which circumstance should you create an index on a table?
If the master device is full, how do I make the master database bigger?
What is a database call?
What is a trace file?