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...

what is rank and dense rank in informatica with any
examples and give sql query for this both ranks

Answer Posted / sunil

dense rank means it is the process of calculating rank for
each group.

deptno rank
10 1
2
3

20 1
2
3

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Design time, run time. If you don't create parameter what will happen

1827


How to update a particular record in target with out running whole workflow?

1568


permutations of mapplet

2489


EXL informatica Questions

1359


What are the measure objects?

1186


What is an expression transformation in informatica?

1007


how to load dimension table and fact table. plz tell me the steps.

2084


What is meant by query override?

1043


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10123


What is a predefined event?

1082


Briefly define reusable transformation?

1115


What is the function of aggregator transformation?

1067


What is the session task and command task?

1034


In informatics server which files are created during the session rums?

1106


What is flashback table ? Advance thanks

1921