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


Please Help Members By Posting Answers For Below Questions

How to do Stored procedure testing? Who does this testing (Developer or tester)?

1387


What does new grouping sets enables you to do?

604


what is the role of auditor in auditing data oriented applications?

1933


How do I setup a database connection?

520


what is data access layer?

1982






Explain entity set?

587


WHAT KIND OF TOOL BO IS?

1844


Explain entity ?

602


Explain the various types of normalization.

645


What are the various ways to execute a query in teradata?

2195


What is the purpose of TNS?

664


What is the role of tester in discovery(in Checklist)?

1461


Is storing images in a database a good idea?

548


What is database schema name?

582


Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

1812