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 generate sequence numbers?

1098

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1279

---

What is the command used to run a batch?

1078

---

What are the new features of Power Center 5.0?

1790

---

update strategy transformation in informatica

1074

---

What are the settings that you use to configure the joiner transformation?

1059

---

differences between service based and product based?

2022

---

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

1592

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1086

---

What are mapplets?

1284

---

What is meant by incremental aggregation?

1120

---

what is size of u r database?

2319

---

What is parallel processing in informatica?

1720

---

How can you generate reports in informatica?

1041

---

whats the logic to load the lower level of granularity of data to fact table.

2281

---