Answer / chanti

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.

A materialized view can be stored in the same database as its base table(s) or in a different database.
Materialized views stored in the same database as their base tables can improve query performance through query rewrites. Query rewrites are particularly useful in a data warehouse environment.

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,

---

What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.

4 Answers  

---

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,

---

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

---

What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,

---

Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,

---

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

---

what is confirmed dimension?

6 Answers  

---

what are the types of facts with Examples?

3 Answers  

---

What is informatica powercenter repository?

0 Answers  

---

Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation

1 Answers   Puma,

---

How to display null values on a target & non-null values on a target?

3 Answers  

---