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
What is the purpose of TNS?
What is the purpose of firebase?
What is the advantage of varchar2 over char?
What is the use of default key?
if i want to display the name of students such that to which city they belong must have count greaer than two
What is the concept of Virtual field?
If the master device is full, how do I make the master database bigger?
What is meant by distributed system?
what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?
Explain entity type?
What is relational database with example?
Define stored procedure?
What is replicaset?
What is the difference between specialization and generalization?
Explain alternate key?