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
- 27635 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 |
Explain target update override in informatica
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How to create or import flat file definition in to the warehouse designer?
how we can update a target table without update strategy and update override?
what is informatica metadata?
What are active transformations.
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
When will you use SQL override in a lookup transformation?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
what are the row and column separations in Flat Files
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
what are testing in a mapping level please give brif eplanation
Teradata 
