Get fully solved assignment, plz drop a mail with your sub code
computeroperator4@gmail.com
Charges for mba rs 125/subject and rs 700/semester only.
For other rs 125/subject only
if urgent then call us
on 08791490301, 08273413412
Fall
2014
PROGRAM
BCA(REVISED 2007)
SEMESTER
6
SUBJECT
CODE & NAME BC0058 – DATA WAREHOUSIN
Qus:1
What is a Data Warehouse? What functionality does data warehouse provide?
Answer:
Data
Warehouse:
A Data Warehouse
is a relational database that is designed for query and analysis rather than
for transaction processing.
It usually
contains historical data derived from transaction data, but it can include data
from other sources. It separates analysis workload from transaction workload
and enables an organization to consolidate data from several sources.
Qus:2 (a) Differentiate Data Warehouse database and
OLTP Databases.
(b) What does Single Vendor approach provides while
Planning your Data Warehouse?
Answer:
Differentiate Data Warehouse database
and OLTP Databases:
Qus:3 a) Write the list of Components of Data
Warehouse Architecture.
b) Explain Internal data.
Answer:
The list of Components of Data Warehouse
Architecture:
The major
components of DWH Architecture are:
1. Source Data Component
Qus:4 Explain the strengths of Dimensional modeling?
Answer:
The strengths of Dimensional Modeling:
The dimensional
model has a number of important data warehouse advantages that the E-R model
lacks. Its strengths are:
1.
The
dimensional model is a predictable, standard framework. Report writers, query
tools, and end user interfaces can all make strong assumptions to make the user
interfaces more understandable and to make processing more efficient.
Qus:5 Explain the basic tasks in Data
Transformation.
Answer:
The Basic tasks in Data Transformation:
The data
transformation contains the following basic tasks:
·
Selection: This takes
place at the beginning of the whole process of data transformation. You select
either whole records or parts of several records from the source systems. The
task of selection usually forms part of the extraction function itself.
Qus:6 Write the list of major levels that CMM
contains. Explain about the “Level 1 – Performed Informally”
Answer:
The list of Major Levels that CMM
Contains:
CMM contains
five major levels:
Get fully solved assignment, plz drop a mail with your sub code
computeroperator4@gmail.com
Charges for mba rs 125/subject and rs 700/semester only.
For other rs 125/subject only
if urgent then call us
on 08791490301, 08273413412
No comments:
Post a Comment