True/False
GENERIC RETAILER
Observe the ER diagram for the Generic Retailer:
Assume that the dimension PRODUCT containing the following columns:
ProductKey (surrogate key)
ProductID
ProductDescription
ProductBrandID
ProductBrandName
ProductCategoryID
ProductCategoryName
is created for the Generic Retailer.This dimension will be used for the following questions citing Generic Retailer PRODUCT dimension.
-A user using an OLAP query (based on the dimensionally modeled data set that contains the ABC Retailer dimension PRODUCT)can drill up from ProductID to ProductCategoryID.
Correct Answer:

Verified
Correct Answer:
Verified
Q12: The purpose of the drill down operation
Q13: GENERICDATA<br>Observe the tables GENERICDIMENSION and GENERICFACT:<br><br>
Q14: GENERICDATA<br>Observe the tables GENERICDIMENSION and GENERICFACT:<br><br>
Q15: Illustrate a typical HOLAP architecture.
Q16: OLAP tools are:<br>A)Write-only tools<br>B)Read-only tools<br>C)Read and write
Q18: What is a first load?
Q19: OLAP/BI tools can be used for:<br>A)Ad-hoc direct
Q20: OLAP/BI tools are designed for the analysis
Q21: What takes place during the transformation part
Q22: Which of the following processes is typically