Dynamic and materialized view
Write a short note on the difference between a dynamic and materialized view?
Expert
A dynamic view might be created every time that a particular view is requested by a user. A materialized view is created and updated infrequently and it should be synchronized with its associated base table(s).
Consider a MOVIEdatabase in which data is recorded about the movie industry. The data requirement an u will given me this solution
Explain the Aggregator Transformation?
Write down the purpose of Fact-less Fact Table?
Why there is a need to create the user object?
How would the developer describe all variables using referential data types?
Give a brief introduction of the term Virtual Data Warehousing?
Specify different types of transformations available in the Informatica?
Define the term spanning Tree?
What are the two means to explain the content of XML documents?
Explain the term DataStage and Informatica?
18,76,764
1930447 Asked
3,689
Active Tutors
1438452
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!