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

which background process will run @ the time of creation of catalog database

1 Answers CSC,

What is replication? : sql server DBA

0 Answers

deleted of control file how will u recover control file?

4 Answers CTS,

Why would you call update statistics? : sql server DBA

0 Answers

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers

how can you create a user-defined lock?

0 Answers Oracle,

What is checkpoint?

3 Answers Accenture,

how can you initialize log miner?

0 Answers Oracle,

What is blocking and how would you troubleshoot it?

1 Answers

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers Cognizant,

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here