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
- 27670 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 |
what are challenges that you faced in testing? give solution to it?
When you move from devel to prod how will you retain a variable
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
how we load the data from source to staging area
How to eliminate 1st and last rows from the source and load the inbetween rows.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Explain the aggregator transformation?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
what is the size of u r source(like file or table)?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
what is datamart
EXL informatica Questions
Teradata 
