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
- 27770 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 the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the difference between source qualifier transformations source filter to filter transformation?
How does the aggregator transformation handle null values?
What are multi-group transformations?
Explain in detail scd type 2 through mapping.
Explain about Informatica server process that how it works relates to mapping variables?
What all are steps in up gradation of Informatica server?
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?
Why filter transformation is an active one?
explain about unit testing? in real time?
Explain the informatica workflow?
What is a dimensional model?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
explain abt ur project architecture?
What is the commit type if you have a transaction control transformation in the mapping?
