Answer Posted / papa

Materialized View caches the data,but view cannt store the
data all.

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 are the conditions needed to improve the performance of informatica aggregator transformation?

1134

---

how we can load rejected record's at run time?(not through bad files)

2422

---

Briefly describe lookup transformation?

1090

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1906

---

What are the types of caches in lookup? Explain them.

1009

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2288

---

scenario where i can use only concurrent execution of workflow.

3251

---

What are the reusable transformations?

1211

---

Do you find any difficulty while working with flat files as source and target?

1146

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2169

---

What is expression transformation?

1142

---

What is the use of an aggregator cache file?

1245

---

Performance tuning in UNIX for informatica mappings?

2620

---

How do you load only null records into target?

1249

---