Answer Posted / sushma

you can use SQL transformation

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1901

---

What is confirmed fact in dataware housing?

6968

---

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

1070

---

How can we create index after completion of load process?

1125

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2280

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2261

---

How are indexes created after completing the load process?

1644

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1153

---

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

2744

---

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

1132

---

What do you understand by term role-playing dimension?

1048

---

Explian the Process of deployment groups in informatica

1062

---

Why do you use Mapping Parameter and mapping variable?

1763

---

Enterprise data warehouse your projects phase by phase explain?

1921

---

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

1909

---