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

in informatica workflow has 5 sessions and running seqentially and 3rd session has been failed how can we run again from only 3rd to 5th session

1 Answers  


What is database server and how it works?

0 Answers  


How do you connect to a database?

0 Answers  


What is ole db ado?

0 Answers  


How many types of locks are present in a database?

0 Answers   Abacus,


WHAT IS CARDINALITIES OF JOIN?

0 Answers  


What are database connection details?

0 Answers  


Explain normalization in one line?

0 Answers   C DAC, CDAC,


WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

0 Answers   Wipro,


Explain the record term used in database.

0 Answers  


What is Data Modelling?

0 Answers   Informatica,


How do you pass parameter in stored procedure?

0 Answers   CGI,


Categories