What Is Meant By Aggregate Fact Table And Where Is It Used?

1.	What Is Meant By Aggregate Fact Table And Where Is It Used?
Answer» BASICALLY fact TABLES are two kinds. AGGREGATED fact table and Factless fact table. Aggregated fact table has aggregarted columns. for EG. Total-Sal, Dep-Sal. where as in factless fact table will not have aggregated columns and it only has FK to the Dimension tables. Basically fact tables are two kinds. Aggregated fact table has aggregarted columns. for eg. Total-Sal, Dep-Sal. where as in factless fact table will not have aggregated columns and it only has FK to the Dimension tables.

Answer»

AGGREGATED fact table and
Factless fact table.

Aggregated fact table has aggregarted columns. for EG. Total-Sal, Dep-Sal. where as in factless fact table will not have aggregated columns and it only has FK to the Dimension tables.

Basically fact tables are two kinds.

Aggregated fact table has aggregarted columns. for eg. Total-Sal, Dep-Sal. where as in factless fact table will not have aggregated columns and it only has FK to the Dimension tables.

Discussion

No Comment Found

Related InterviewSolutions

When We Create A Target As Flat File And Source As Oracle. How Can I Specify First Rows As Column Names In Flat Files?
What Is Meant By Direct And Indirect Loading Options In Sessions?
What Is Difference Between Informatica 7.1 And Abinitio?
How To Join Two Tables Without Using The Joiner Transformation?
Difference Between Static And Dynamic Cache And Explain With One Example?
How The Informatica Server Sorts The String Values In Ranktransformation?
What Is Data Merging, Data Cleansing, Sampling?
What Are The Unsupported Repository Objects For A Mapplet?
Discuss Which Is Better Among Incremental Load, Normal Load And Bulk Load.
What Is Update Strategy Transformation ?

What Is Meant By Aggregate Fact Table And Where Is It Used?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment