Answer / 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

Answer / ravikumar2614

Rank creates gaps where as densc Rank will not create gaps(between two ranks).
1st answer is correct

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

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

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

0 Answers  

---

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,

---

What is pmcmd command?

0 Answers  

---

What is limitations of truncate and load option

1 Answers   Cap Gemini,

---

Diff b/w ShortCut and reusabel Object ?

4 Answers  

---

What do you mean by blocking transformation?

0 Answers  

---

How the informatica server increases the session performance through partitioning the source?

1 Answers  

---

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers   Accenture,

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

What is the maplet?

0 Answers   Informatica,

---

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

---

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,

---