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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of TNS?

981


What is the purpose of firebase?

931


What is the advantage of varchar2 over char?

1212


What is the use of default key?

1084


if i want to display the name of students such that to which city they belong must have count greaer than two

2170


What is the concept of Virtual field?

2006


If the master device is full, how do I make the master database bigger?

910


What is meant by distributed system?

938


what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?

2259


Explain entity type?

945


What is relational database with example?

897


Define stored procedure?

969


What is replicaset?

941


What is the difference between specialization and generalization?

968


Explain alternate key?

1015