Answer / abhinaw prakash

When we issue Select * from View it'll fetch the data from
the Base table were as with Materialized view when we issue
select * from Materialized view it ll fetch the data from
the materialized view.

Also with using materialized view we can escape the run time
joins that it ll have to do when retrieving for a query.

Also with View you cannot schedule it for refresh but with
MV we can schedule it for Refresh

Why filter transformation is an active one?

0 Answers  

---

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,

0 Answers   HCL,

---

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

0 Answers   Puma,

---

how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,

---

What is a surrogate key?

0 Answers  

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  

---

Explian the connected and unconnected lookup transformation

1 Answers   Informatica,

---

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

---

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

---

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,

---

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

---