What Is Snowflake Schema?

1.	What Is Snowflake Schema?
Answer» Snowflake schema is defined in which a SINGLE fact table is connected to multiple DIMENSION TABLES. The dimension are STRUCTURED to minimize update anomalies and to address single THEMES. Snowflake schema is defined in which a single fact table is connected to multiple dimension tables. The dimension are structured to minimize update anomalies and to address single themes.

Answer»

Snowflake schema is defined in which a SINGLE fact table is connected to multiple DIMENSION TABLES. The dimension are STRUCTURED to minimize update anomalies and to address single THEMES.

Snowflake schema is defined in which a single fact table is connected to multiple dimension tables. The dimension are structured to minimize update anomalies and to address single themes.

Discussion

No Comment Found

Related InterviewSolutions

For Whom Is Sas Data Integration Studio Designed?
Why Is Sas Data Integration Studio Important?
Explain The Difference Between Alternate Key, Business Key, Foreign Key , Generated Key , Primary Key, Retained Key And Surrogate Key ?
Describe The Interaction Table In Sas Di?
What Is Change Analysis In Sas Di ?
Name The Scheduler For Scheduling Job And Explain The Scheduler?
Describe About Metadata Object?
Name Some Data Transformation Used In Sas Di?
What Is The Use Of Sas Management Console?
What Is Operational Data And Operational System?

What Is Snowflake Schema?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment