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

How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

10 Answers   Wipro,

---

What is the difference between router and filter?

0 Answers  

---

What are the data movement modes in informatcia?

1 Answers  

---

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

---

how can we run workflow with pmcmd?

3 Answers   Wipro,

---

---

how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,

---

how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,

---

what is work of PUSH DOWN option

2 Answers   Wipro,

---

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  

---

How Union Transformation is an Active Trans?

6 Answers  

---

how many ways can we implement SCD2?

4 Answers   IBM, TCS,

---

What are the different caches used in informatica?

3 Answers   UST,

---