Answer / shruthi

Materialized views are schema objects that can be used to
summarize, precompute, replicate, and distribute data. E.g.
to construct a data warehouse.

A materialized view provides indirect access to table data
by storing the results of a query in a separate schema
object. Unlike an ordinary view, which does not take up any
storage space or contain any data.

Answer / mike

Well in simple terms
A meterialized view is a view that contains data in some
temporary tables. If we consider the view at database level
it only stores the query , when ever we call the view it
extracts the data from the database based on the query...

Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers   TCS,

---

Explain the shared cache and re-cache?

0 Answers  

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---

Could you explain what is enterprise data warehouse?

0 Answers  

---

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

---

---

What are two types of processes that informatica runs the session?

2 Answers  

---

what is semi-additive fact?where did u used?

2 Answers  

---

What is the surrogate key?

0 Answers  

---

how to get the only updated records in the target

2 Answers  

---

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,

---

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,

---

(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 Answers  

---