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...

what is materialized view?

Answer Posted / 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...

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the databases that informatica can connect to windows?

1095


What is a connected transformation?

1183


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6580


On which transformations you created partitions in your project?

1431


What are mapplets?

1326


What is the function of look up transformation?

1173


What are the restrictions of union transformation?

1084


What is InformaticaPowerCenter?

1177


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1340


Explain informatica architecture - version 8 / 9

1146


In development project what is the process to follow for an etl developer from day1

1758


How do you convert single row from source into three rows into target?

1210


How to handle decimal places while importing a flatfile into informatica?

1240


Clarify the utilization of aggregator cache record?

1043


What do you mean by channel change?

1105