Interested to Buy Any Domain ? << Click Here >> for more details...
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
What do you mean incremental aggregation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain about Informatica server process that how it works relates to mapping variables?
What does “tail –f” command do and what is its use as an Informatica admin.
How can we handle two sessions in informatica?
How can you differentiate between powercenter and power map?
What is session task and command task?
How are the sources and targets definitions imported in informatica designer?
what is $$$$?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is workflow? What are the components of the workflow manager?
How to load data in informatica ?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
As union transformation gives UNION ALL output, how you will get the UNION output?
