Answer Posted / abhinaw prakash
When we issue Select * from View it'll fetch the data from
the Base table were as with Materialized view when we issue
select * from Materialized view it ll fetch the data from
the materialized view.
Also with using materialized view we can escape the run time
joins that it ll have to do when retrieving for a query.
Also with View you cannot schedule it for refresh but with
MV we can schedule it for Refresh
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Why is sorter an active transformation?
Informatica settings are available in which file?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is depict expression change?
wat are deployement groups in informatica, how it will be used for developers
How will the document be delivered to me?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Tell me about MD5 functions in informatica
What is union transformation in informatica?
Explain the mapping variable usage example in informatica
How can we delete duplicate rows from flat files?
What does “tail –f” command do and what is its use as an Informatica admin.
Write the prerequisite tasks to achieve the session partition?
Explain why we use partitioning the session in informatica?
