What Are The Tables Used By Obia?

1.	What Are The Tables Used By Obia?
Answer» Aggregate tables (_A) : These tables contain summed (aggregated) data. Dimension tables (_D) : Dimension tables with descriptive data Staging tables for Dimension(_DS) :These tables contain the data which is to be loaded to Target Fact tables (_F) : Tables storing facts and measures Dimension HIERARCHY tables (_DH) : Tables that store the dimension's hierarchical structure Fact Staging tables (_FS) : Staging tables used to HOLD the metrics being ANALYZED by dimensions that have not been through the ﬁnal ETL transformations.

Answer»

Aggregate tables (_A) : These tables contain summed (aggregated) data.
Dimension tables (_D) : Dimension tables with descriptive data
Staging tables for Dimension(_DS) :These tables contain the data which is to be loaded to Target
Fact tables (_F) : Tables storing facts and measures
Dimension HIERARCHY tables (_DH) : Tables that store the dimension's hierarchical structure
Fact Staging tables (_FS) : Staging tables used to HOLD the metrics being ANALYZED by dimensions that have not been through the ﬁnal ETL transformations.

Discussion