Give The Two Types Of Tables Involved In Producing A Star Schema And

1.	Give The Two Types Of Tables Involved In Producing A Star Schema And The Type Of Data They Hold?
Answer» Fact tables and DIMENSION tables. A fact table contains MEASUREMENTS while dimension tables will contain DATA that will help describe the fact tables. Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

Give The Two Types Of Tables Involved In Producing A Star Schema And The Type Of Data They Hold?

Answer»

Fact tables and DIMENSION tables. A fact table contains MEASUREMENTS while dimension tables will contain DATA that will help describe the fact tables.

Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

Discussion

No Comment Found

Related InterviewSolutions

How Can You Detect Block Corruption?
How Do You Handle Ora-01403: No Data Found Error?
What Are The Different Types Of Locking Modes?
Name A Few Places You Will Look To Get More Details On A Performance Issue?
Describe The Oracle Wait Interface?
How Can You Monitor Performance Of The Database Proactively?
Which Trace File Is Used For Performance Tuning And Why?
What Do The Db_file_sequential_read And Db_file_scattered_read Events Indicate?
What Do You Understand By Db File Scattered Read?
What Is The Main Reason For Block Corruption?

Give The Two Types Of Tables Involved In Producing A Star Schema And The Type Of Data They Hold?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment