Rank creates gaps where as densc Rank will not create gaps(between two rank

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

Question Posted / ravikumar2614

Answer Posted / ravikumar2614

Rank creates gaps where as densc Rank will not create gaps(between two ranks).
1st answer is correct

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain the mapping variable usage example in informatica

1110

What is main use of mapplet?

1094

What is the use of transformation?

968

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1046

r u done any partitions in ur project?

1783

What is the advantage of informatica?

1030

What are the types of data warehouses?

1455

What is deployment group?

1153

What is meant by a domain?

1098

What is Index Caches size?

1078

How many dimensions are there in informatica?

1052

How to call shell scripts from informatica?

953

what is unit testing?tell me proceedure

2186

Explain what transformation and how many are there in informatica?

905

Different sorts of metadata that stores in the storage facility?

974