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
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
what is mean by complex business rule ?
Where are the source flat files kept before running the session?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How can one identify whether mapping is correct or not without connecting session?
What is transformation?
Under which circumstances, informatica server creates reject files?
What is the use of an aggregator cache file?
What do you understand by a term domain?
Which transformation should we use to normalise the COBOL and relational sources?
What are multi-group transformations?
What is sq transformation?
Explain lookup transformation source types in informatica
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?