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

How to create or import flat file definition in to the warehouse designer?

1024

---

What do you mean by blocking transformation?

973

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3652

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1037

---

Explain the shared cache and re-cache?

1052

---

Explain joiner transformation in informatica

1077

---

What is the difference between router and filter?

1156

---

How to join three sources using joiner?

1033

---

Explain the difference between mapping parameter and mapping variable?

982

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1006

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1509

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1808

---

What is data caches/ index caches?

1024

---

What are the differences between oltp and olap?

923

---

How do you promote a non-reusable transformation to reusable transformation?

1071

---