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
- 27642 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
Explain what is informatica metadata and where is it stored?
Explain about cumulative Sum or moving sum?
What is an Integration service in Informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How we can use union transformation?
What is intricate mapping?
What is a rank transform?
what is the Default Source Option For Update Strategy Transformation?
State the differences between sql override and lookup override?
explan ur project architecture?
How to generate sequence numbers without using the sequence generator transformation?
How do you handle two sessions in Informatica
Describe an informatica powercenter?
How does a rank transform differ from aggregator transform functions max and min?
Explain informatica architecture - version 8 / 9
