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
7512 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 to determine the service pack currently installed on SQL Server?

1 Answers

What is transparent data encryption? : sql server DBA

0 Answers

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers IBM,

Describe what redo logs are.

1 Answers

Name two files used for network connection to a database.

5 Answers

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers

What is the default fill factor value? : sql server DBA

0 Answers

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers

Give the reasoning behind using an index.

2 Answers

what is a user-defined lock?

0 Answers Oracle,

now one user in online.now i want drop him..how do u drop him?

4 Answers Wipro,

What view would you use to determine free space in a tablespace?

3 Answers

For more DB Administration Interview Questions Click Here