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.
Distinguish between the query answering and direct query answering.
Explain the way to audit the SQL sent to the server.
What is meant by the term business objects?
What are the utilities Oracle gives, which are utilize for backup and recovery?
Briefly describe the employ of aggregate tables and lookup tables?
How can we remove duplicate rows from the flat file?
Explain the types of jobs we have within the Data stage?
What are the techniques in which an Oracle database can be created?
Illustrates architecture of reporting services?
State the components of report studio?
18,76,764
1945425 Asked
3,689
Active Tutors
1429913
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!