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

wat is global index and local indes

1 Answers Oracle,

What are the ways tablespaces can be managed and how do they differ?

2 Answers IBM,

Explain the concept of the DUAL table.

3 Answers

How many packages we have in db

1 Answers Tesco,

how can you enable flashback feature?

0 Answers Oracle,

From the database level, how can you tell under which time zone a database is operating?

1 Answers

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers Cognizant,

What the different components in replication and what is their use? : sql server DBA

0 Answers

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers

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

0 Answers

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers

For more DB Administration Interview Questions Click Here