Answer Posted / pramod bm

You can use the mapping parameters/variables in other mappings also but only with the help of reusable transformation. If it is not a reusable transformation then you cannot use parameters/variables in other mappings.

What is the function of look up transformation?

1121

---

What is a pre-defined event and user-defined event?

1035

---

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,

7177

---

How to load data in informatica ?

999

---

How to load a Dimension ? and how to load a fact table?

1408

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7378

---

Enlist few areas or real-time situations where informatica is required.

1070

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1047

---

Where can we find the throughput option in informatica?

1057

---

What is the Process to creating lookup transformation in informatica

1038

---

In development project what is the process to follow for an etl developer from day1

1712

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2069

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2510

---

How do you load alternate records into different tables through mapping flow?

1844

---

What are the types of schemas we have in data warehouse and what are the difference between them?

936

---