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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the function of aggregator transformation?

589


Difference between Target-based loading and constraint-based loading?

564


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1707


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6762


How to generate sequence numbers?

628






What is aggregator transformation in informatica?

553


What are the measure objects?

677


How many dimensions are there in informatica?

640


waht type of interface is used for testing the data in informatica

1846


server hot-ws270 is connect to Repository B. What does it mean?

1869


Partition, what happens if the specified key range is shorter and longer

2035


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1026


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1459


define galaxy repository in informatica

1736


What is meant by lookup transformation?

621