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
- 4 Answers
- 27697 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
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
lookup transformation with screenshots
can u give example for factless fact table
Explain the tuning lookup transformation - informatica
How can we delete duplicate rows from flat files?
What is a shortcut and copy in Informatica and how two are different with each other?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What do mean by local and global repository?
Difference between Target-based loading and constraint-based loading?
What is lookup change?
How to differentiate between the active and passive transformations?
How do you load first and last records into target table?
Explain the aggregator transformation?
What are connected or unconnected transformations?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
