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
- 27844 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 |
how did u understand business requirement?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
Describe the impact of several join conditions and join order in a joiner transformation?
what is row level and column level indicator?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
Which files are created during the session rums by informatics server?
Differentiate between Load Manager and DTM?
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
What is active and passive transformation?
Could you explain what is enterprise data warehouse?
What are the modules in Power Center
Teradata 
