how to implement dense rank in rank transformation in Informatica? so that ou

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

Question Posted / shubh_p

1 Answers
14720 Views
I also Faced
E-Mail Answers

how to implement dense rank in rank transformation in Informatica? so that output should be like ..

Answer / 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

More Databases AllOther Interview Questions

Data structure used to implements a menu:

0 Answers Verifone,

What is the database url?

0 Answers

wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

0 Answers

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

0 Answers

How do I manually create a database?

0 Answers

If we execute an query in MLOAD it's ran successfully, my questions is after successfully ran MLOAD. In error tables we can see anything there! is it possible than what are they?

3 Answers CTS,

What is the difference between database and server?

0 Answers

Explain partial key?

0 Answers

What is the difference between data source and database?

0 Answers

if we have set auto differencial back up then waht is difference between 1.appen to media 2.over right the existing media

1 Answers Indian Web Technology,

what is the difference between tuple calculus and domain calculus ?

2 Answers Infosys,

utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN

2 Answers Accenture,

For more Databases AllOther Interview Questions Click Here