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
7635 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

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers

how can you create a user-defined lock?

0 Answers Oracle,

How do you add a data file to a tablespace?

3 Answers

one datafile is lost in standy side how can you recover that??

2 Answers

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers Oracle,

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers

How would you determine who has added a row to a table?

4 Answers

How can you rebuild an index?

6 Answers

What the different topologies in which replication can be configured? : sql server DBA

0 Answers

How do you resize a data file?

2 Answers

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers

Where in the Oracle directory tree structure are audit traces placed?

1 Answers

For more DB Administration Interview Questions Click Here