Answer Posted / koti

Re: How do you create single lookup transformation using
multiple tables?
Answer
# 1 Lookup transformation: Based upon one/more keys the
data is
retreived from one/more tables.

create a single lookup transformation by Joining the
multiple tables, having connected the keys defined in
lookup tranformation.

What is the need of etl tools?

1180

---

What is a dimensional model?

1033

---

Define joiner transformation?

1102

---

Explain the tuning lookup transformation - informatica

1044

---

What do you mean by filter transformation?

1003

---

What is informatica powercenter repository?

1256

---

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

1131

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7235

---

Explain how to import oracle sequence into informatica?

1071

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1327

---

What is the benefit of session partitioning?

1157

---

Have you worked with/created Parameter file

1713

---

What is meant by query override?

1115

---

What are the components of the workflow manager?

1181

---

Under which circumstances, informatica server creates reject files?

1139

---