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
How does non-cluster index functions?
After normalization, what are the conditions which have to keep in mind to de-normalize it?
What is database and its types?
give a simple example of physical and logical data independence
how can you perform lookup range in lookup stage expalin in detail?
what is transaction state, buffer management, shadow paging
How to shrink a database?
i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?
Is data lake a database?
What is lagging in DBMS ?
What is relational database with example?
Can a database table exist without a primary key?
What is a database call?
What are different types of resources?
5. Explain about relational algebra.