for eg: the file contains the records with coulmn 100 200(repeated rows)

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

Question Posted / rajashekhar

4 Answers
27840 Views
I also Faced
E-Mail Answers

Answer Posted / rajashekhar

for eg: the file contains the records with coulmn
100
200(repeated rows)
200
300
400
500
the rank function gives output as
1
2
2
4
5
6
and dense rank gives
1
2
2
3
4
5

Is This Answer Correct ?

32 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the new features of informatica 9.x at the developer level?

1050

Which files are created during the session rums by informatics server?

1190

what is degenerated dimension?

4008

define galaxy repository in informatica

2238

What will be the approach?

995

What is the status code in stored procedure transformation?

1189

What are the prerequisite tasks to achieve the session partition?

1263

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2135

Write the different tools in the workflow manager?

1075

What is lookup transformation?

1048

What is the function of look up transformation?

1130

What is the difference between a repository server and a powerhouse?

1522

What is rank index in rank transformation?

1084

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1632

Performance tuning( what you did in performance tuning)

1998