Whatis the difference between View and Materialized View ?
Answer Posted / guest
In view we cannot do DML commands where as it is possible
in Materialized view.
| Is This Answer Correct ? | 39 Yes | 121 No |
Post New Answer View All Answers
What is confirmed fact in dataware housing?
Differentiate between a database and data warehouse?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to elaborate powercenter integration service?
What do you mean by filter transformation?
What is a joiner transformation?
How do you load unique records into one target table and duplicate records into a different target table?
What is a rank transform?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Could you explain what is enterprise data warehouse?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is informatica metadata and where is it stored?
How we can use union transformation?
Difference between Target-based loading and constraint-based loading?
What is the sql query overwrite in source qualifier in informatica