Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to handle multi value dimensions?
Explain the structure of cold fusion?
What is perform recovery?
How are models actually derived?
What are the data types present in bo?
How can we load the time dimension?
What is latest version of power center / power mart?
I know of using applysimple, but there are other ways too?
Why should you put your data warehouse on a different system than your oltp system?
What is application.cfm?
What are situations where snowflake schema is better than star schema when the opposite is true?
What is the difference between dependent data warehouse and independent data warehouse?
What are the reasons to use a chameleon method in data warehousing?
What is the function of etl when used in data warehousing?
What are the key columns in Fact and dimension tables?
