Whatis the difference between View and Materialized View ?

Answer Posted / navas

View:It is a sql query which is executed and populates
results each time when the particular view is accessed.When
we make a DML statement in view it will affect the original
data available in datebase table.
Materialized view:Materialized view is similar to a table
that exists in the table space.The resultsets are fetched
and populated in materialized view from various table when
a meterialixed view is created and will be availabe until
the view is refreshed.

Is This Answer Correct ?    18 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1647


what is mean by complex business rule ?

1909


Where are the source flat files kept before running the session?

848


How do you remove duplicate records in informatica? And how many ways are there to do it?

918


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

852


How can one identify whether mapping is correct or not without connecting session?

1155


What is transformation?

881


Under which circumstances, informatica server creates reject files?

836


What is the use of an aggregator cache file?

919


What do you understand by a term domain?

878


Which transformation should we use to normalise the COBOL and relational sources?

966


What are multi-group transformations?

794


What is sq transformation?

857


Explain lookup transformation source types in informatica

896


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

831