question

OraLearner avatar image
OraLearner asked

Give the two types of tables involved in producing a star schema ?

What are the two types of tables involved in producing a star schema and the type of data they hold ? Thank you.

oracletablesschema
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KillerDBA avatar image KillerDBA commented ·
Is there some specific reason you haven't approved the answer? Do you have some reason to believe the answer isn't reasonably correct? Did you read the Wiki article?
0 Likes 0 ·
OraLearner avatar image OraLearner commented ·
yes..Article is nice one..Thank you for reminding me..i'll really appreciate your answers.
0 Likes 0 ·

1 Answer

·
KillerDBA avatar image
KillerDBA answered

There are, typically, dimension tables and fact tables.

The dimension tables's PKs are typically elements of a giant, compound PK on the fact table(s). However, physical characteristics, access methods, storage methods, etc of your database software might suggest alternative physical implementations of a star schema.

Wiki has an article on it:

Wiki on Star Schemas

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

OraLearner avatar image OraLearner commented ·
I've gone through this article when you post the answer. But missed to accept the answer.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.