Advantages of data warehousing
State the different advantages of the data warehousing?
Expert
Following advantages are offered by the data warehousing:
a) It develops the quality and accessibility of the data. b) It capitalizes over the potential value of organization’s information. c) It combines the valuable archive data along with the latest data within the operational sources. d) It improves the amount of information which is available to the users. e) It reduces the requirement of the users in order to access the operational data. f) It decreases the strain on the IT departments, since they may gnerate one database to serve all the user groups.
Explain how do you produce the Sequence number within the Data stage?
Describe briefly the term data warehouse?
Explain, why we use the lookup transformations?
Write down a short note on the Volatile Temporary tables (VTT).
Define the term Event studio?
Explain what is meant by the term catalog and its types in the cagonos?
Specify the types of the tracing level?
Describe the term HOLAP.
State the different steps of data warehouse design process.
Name the methods and types of Collision Resolution Techniques used in each of the type?
18,76,764
1927568 Asked
3,689
Active Tutors
1423653
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!