1. Categories >> Software >> Databases >> Databases AllOther
  2. Suggest New Category

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


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

What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?

0 Answers   BDI Systems, Google,

During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?

0 Answers  

Explain alternate key?

0 Answers  

can any one explain about normalization forms with clear explanation in interview point of view. thanks for ur answers.

1 Answers  

What is a super key?

0 Answers   3i Infotech,




Explain the table term used in database.

0 Answers  

What is a reference table in database?

0 Answers  

characters of DBMS A) non redundant B) data independence C) increased security D) all the above

1 Answers   Accenture, XP,

What do you mean by cluster and non cluster index?

0 Answers  

Is it good to store images in database?

0 Answers  

What is a database string?

0 Answers  

What is the difference between primary key, foreign key and candidate key?

0 Answers   Ernst Young,

For more Databases AllOther Interview Questions Click Here
Categories