What is the difference between a table and the materialized
view?
Answer Posted / chandra
TABLE: A TABLE IS HAVING ALL THE COLUMS DATA
WHERE AS
MATERILIZED VIEW : HAVING SELECTED COLUMS DATA WHICH R
DEFINED IN VIEW
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is informatica worklet?
What is lookup change?
How can you define user defied event?
What is the difference between a connected look up and unconnected lookup?
What is the difference between STOP and ABORT options in Workflow Monitor?
What are the different types of repositories created using informatica?
what is size of u r database?
How you prepared reports for OLAP?
In warehouses how many schemas are there?
What does role playing dimension mean?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
how tokens will generate?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
what is SDLC way of code development?
What are junk dimensions?