Metadata Management is applicable at
Source layer
Report Layer
Data Warehouse
All of the above
Metadata for ‘123456TCS’ can be
Format is Employee Number – Number (6), Organization Name – Char (3)
Employee 123456 works for TCS for five years
Employee 123456 has worked in BIPM services
None of the above
An enterprise has multiple ETL and reporting tools. Which of the following Metadata management is recommended
Distributed
Federated
Centralized
Not possible to implement Metadata
_________________can be used by all level of users
Enterprise report
OLAP reports
GIS
Scorecards
Ad-hoc reporting requires predefined report template
True
False
The cube structure in OLAP achieves the __________functionality.
Shared
Information
Collection
Multidimensional
Aggregation provides OLAP with __________
Multidimensional data.
Pre-calculated data.
Nested data.
Slow data retrieval.
What term in OLAP defines changing the dimensional orientation of the report from the cube data?
Dicing
Slicing
Rotating
Nesting
Clustering, Scatter graph, Decision tree , histogram are some of GIS(Graphical Information system) visualizations
Ad hoc, Prestored reports , OLAP are samples for Pull mode of Information delivery