Give the two types of tables involved in producing a star schema and the type o

Give the two types of tables involved in producing a star
schema and the type of data theyhold.

Question Posted / guest

2 Answers
6862 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Give the two types of tables involved in producing a star schema and the type of data theyhold...

Answer / monal

FACT TABLE: SALES
DIMENSION TABLE: GEOGRAPHY, PRODUCT, TIME

Is This Answer Correct ?

3 Yes

1 No

Give the two types of tables involved in producing a star schema and the type of data theyhold...

Answer / jeshani

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More DB Administration Interview Questions

how will you see when the database was started using sql prompt?

2 Answers IBM,

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers

why we use cursors

1 Answers

what is the difference between hot backup n rman backup?

1 Answers Value Labs,

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers

why Datapump is faster than traditional export and import

4 Answers Mphasis,

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?