What is the difference between view and materialised view?
Answer Posted / sarvesh
VIEW IS THE VIRTTUAL TABLE,AND WE CANOT REFRESH THE
DATA ,BUT IN MATERIALISED VIEW WE CAN REFRESH THE DATA
FREQUNENTLY,AND BY USING M.VIEW THE PERFORMANCE WILL BE
INCREASED.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
While importing the relational source definition from the database, what are the metadata of source that will be imported?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How can we create index after completion of load process?
Please let me know how to make encryption and decryption with example?
Differentiate between source qualifier and filter transformation?
What are the components of workflow manager?
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
Differentiate between reusable transformation and mapplet.
What is the use of an aggregator cache file?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Explain sessions and how many types of sessions are there?
Did u used latest transformations of 8.6.0? for what?
Differentiate between joiner and lookup transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is meant by lookup transformation?