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

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

what are the performance views in an oracle rac environment?

0 Answers Oracle,

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers CTS,

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

2 Answers IBM,

how can a session indicate its interest in receiving alerts?

0 Answers Oracle,

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers Infosys,

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

2 Answers Cognizant,

how can you initialize log miner?

0 Answers Oracle,

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers

how can you find out if a table can be redefined?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here