1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / guest

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 background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers   Oracle,

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

0 Answers  

What is the difference between online backup & offline backup?

3 Answers   CSC,

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  




Why would you use sql agent? : sql server DBA

0 Answers  

What is replication? : sql server DBA

0 Answers  

what is a crs resource?

0 Answers   Oracle,

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

how can you implement fine-grained auditing?

0 Answers   Oracle,

Datapump backup steps?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories