Answer Posted / sandipana

select rownum as rank,emp_id,sal from(select
lastname,salary from employees orderby salary desc)
where rownum IN(1,3,5);

What are the differences between oltp and olap?

1018

---

What is the benefit of partitioning a session?

1236

---

Enlist the advantages of informatica.

1100

---

How do you set a varible in incremental aggregation

1945

---

How can you validate all mappings in the repository simultaneously?

1427

---

Is there any way to read the ms excel datas directly into informatica?

1070

---

How identifying bottlenecks in various components of informatica and resolving them?

1181

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1965

---

Can we get 1st record through Informatica(without sequence number).

1521

---

What is the Process to creating lookup transformation in informatica

1091

---

draw informatica architecture 8.6 ?

3932

---

What are the restrictions of union transformation?

1088

---

What is the meaning of up gradation of repository?

2055

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1200

---

How to do unit testing in informatica?

1229

---