Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



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

i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name

0 Answers   Datamatics,


Datatypes are unlimited,true or false?

2 Answers   Infosys,


What is sqlcode -923 ?

1 Answers  


Is database a hardware or software?

0 Answers  


What do you mean by database?

0 Answers  


Explain entity ?

0 Answers  


What are the disadvantages of views in a database?

0 Answers  


What is global database name?

0 Answers  


What is database schema name?

0 Answers  


What are indexes in oracle?

0 Answers   CGI,


a __________ is a virtual table made up of subset of actual table

2 Answers  


Difference between sql and mysql?

0 Answers  


Categories