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

Define the following terms i. Inverted List ii. Candidate Key iii. B-Tree iv. Foreign Key

1 Answers   Ignou,

what is data set ?

1 Answers  

what are wrappers and build ups and what it's use?

0 Answers   TCS,

What is table scan and index scan?

0 Answers  

1.what are components of querystdio and report studio and cognoss connection? 2. how to use prompts in query studio? 3.what is lock and un lock objects? 4.how to test the re[ports in query studio? 5.how to use brust option and when? 6.what is the performance testing? 7.condition explorer whaen your using? 8.in impromptu how do you create cascading prompt? 9.diff between section and group? 10.types filters where you are using group filters and tabular filter? 11.tabular model, tabular references ,tabular set , tabular sql? 12.what is the use of multi[le packages? 13what types of problems arise when create a join? 14.how to provide package sequirety? 15.report server components? 16.how many kinds of quality subjects? 17.how do you specify the joins? 18.how would you maintain the relations in frame work manager? 19.what is usage of segments and how to provide it? 20.governer settings in frame work maneger? 21.how to create filter in frame work manager? 22diffrence between represention layer and physical layer? 23.how to create prompts in frame work manager? 24.what errors occured when verify the model? 25.how to publish package in net work or local system?

1 Answers   Wipro,




What are the tools used for backup and ticketing?

0 Answers   Alcatel-Lucent,

What is database bounce?

0 Answers  

What is the candidate key used for?

0 Answers   BirlaSoft,

What are the three types of anomalies in database and Explain?

9 Answers  

What is the purpose of firebase?

0 Answers  

What is a database string?

0 Answers  

How do you connect to a database?

0 Answers  

For more Databases AllOther Interview Questions Click Here
Categories