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

If informatica has its scheduler why using third party scheduler?

0 Answers  

---

how to use incremental load?

2 Answers   TCS,

---

What is complex mapping?

0 Answers  

---

what is confirmed fact?

2 Answers  

---

How do you change a non-reusable transformation to reusable transformation?

0 Answers  

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2 Answers   Zensar,

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---

How to partition the Session?

0 Answers   Informatica,

---

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

---

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

---

What are the modules in Power Center

0 Answers  

---