Answer Posted / rajesh

select * from emp natural join dept;

What are the performance considerations when working with aggregator transformation?

1157

---

How to differentiate between the active and passive transformations?

1171

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1507

---

What are the different lookup cache(s)?

1123

---

How do you load unique records into one target table and duplicate records into a different target table?

1268

---

tell me the rules and responsblites in our project(my project is development)

1936

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1917

---

What are the main features of Oracle 8i with context to datawarehouse?

2115

---

Could you explain what is enterprise data warehouse?

1150

---

Differentiate between a database and data warehouse?

1148

---

Enlist some properties of sessions.

1088

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2749

---

What is status code in informatica?

1024

---

What is joiner transformation in informatica?

1048

---

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

1925

---