What is the difference between view and materialised view?
Answer Posted / anju
materialized view can be used to precalculate the expensive
joins and aggregates prior to execution and the result is
stored in a table in database and can refer to it in
future. the adv of this is increse in performance.
view is nothing but an sql query stored. it will not store
data in tables
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is enterprise data warehousing?
What is data movement mode in Informatica and difference between them?
What are Dimensional table?
Define mapping and session?
What are the types of caches in lookup?
expain about the tune parameters?
How does a sorter cache works?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is meant by incremental aggregation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How can you validate all mappings in the repository simultaneously?
permutations of mapplet
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is decode in static cache?