Answer Posted / naresh

Metadata describes the data and other structures like
objects, business rules, process, etc.

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,

7232

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7586

---

What is transformation?

1155

---

How might one distinguish in the case of mapping is right or not without associating session?

1193

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1298

---

Clarify the aggregator change?

1073

---

Differentiate between a repository server and a powerhouse?

1170

---

Enlist some properties of sessions.

1135

---

How do you update the records with or without using update strategy?

1160

---

Different sorts of metadata that stores in the storage facility?

1069

---

Define filter transformation?

1142

---

How can we delete duplicate rows from flat files?

1303

---

How to load last n records of file into target table - informatica

1131

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1126

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4244

---