Answer Posted / nitin
Fact table :- It consists of foreign Keys and MEasures(Numeric values)
Dimension :- It provides descriptive information relating to the foreign key in a fact
Eg:- in employee table i have ename empid sal
in manager table i have mname mid and sal
so there are two dimension table
1--> emp table contains enmae eid(PK) sal
2--> Mgr table contains mname mid(PK) sal
Fact table contains
eid(FK) mid(FK) esal and msal
PLease correct me if i'm wrong
| Is This Answer Correct ? | 30 Yes | 6 No |
Post New Answer View All Answers
Explain the difference between oltp and olap?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
Explain what are slowly changing dimensions?
What are session timeout and application timeout?
Explain why denormalization is promoted in universe designing?
How do you define data block size?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
How can you set the session management?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
Explain what is the difference between stop and abort?
Explain multivalued dependency?
How much data hold in one universe.
Explain why are oltp database designs not generally a good idea for a data warehouse?
Can a dimension table contain numeric values?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.