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
- 27831 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / balakrishna
for eg: the file contains the records with coulmn
empno sal
100 1000
200(repeated rows) 2000
200 3000
300 4000
400 5000
500 6000
Rank :
select rank() over (partition by empno order by sal) from
emp
the rank function gives output as
1
2
2
4
5
6
Dense Rank
select dense_rank() over (partition by empno order by sal)
from emp
and dense rank gives
1
2
2
3
4
5
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sunil
dense rank means it is the process of calculating rank for
each group.
deptno rank
10 1
2
3
20 1
2
3
| Is This Answer Correct ? | 3 Yes | 3 No |
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
Write the prerequisite tasks to achieve the session partition?
How to generate the HTML output using Informatica.
How can we create index after completion of load process?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
How can we use mapping variables in informatica?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
How big was your fact table
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
Explain about the concept of mapping parameters and variables ?
Teradata 
