Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How do we implement materialized view?when to use materialized view?

Question Posted / mehul.thakur


How do we implement materialized view?when to use materialized view?..

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.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Informatica Interview Questions

Differentiate between joiner and lookup transformation?

0 Answers  

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

How you prepared reports for OLAP?

0 Answers  

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

0 Answers   Informatica,

which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  

What are the tasks that source qualifier performs?

1 Answers  

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers  

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,

Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,

While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories