CustomerDimension |
NAME |
DataType |
Cust_code(sk) |
Number(6) |
CustomerID(nk) |
Number(6) |
CustomerName |
VarChar2(20) |
Company |
VarChar2(20) |
Address |
VarChar2(30) |
City |
VarChar2(10) |
State |
VarChar2(10) |
Country |
VarChar2(10) |
ContactNumber |
Number(12) |
Pincode |
Number(6) |
|
ProductDimension |
NAME |
DataType |
Prod_code(sk) |
Number(6) |
ProductID(nk) |
Number(6) |
ProductName |
VarChar2(20) |
CustomerName |
VarChar2(20) |
Company |
VarChar2(20) |
SuplierAddress |
VarChar2(30) |
SupplierCity |
VarChar2(10) |
State |
VarChar2(10) |
QuantityperUnit |
Number(10) |
UnitPrice |
Number(12,2) |
|
|
|
EmployeeDimension |
NAME |
DataType |
Emp_code(sk) |
Number(6) |
EmployeeID(nk) |
Number(6) |
EmployeeName |
VarChar2(20) |
BirthDate |
Date |
HireDate |
Date |
Address |
VarChar2(30) |
City |
VarChar2(10) |
State |
VarChar2(10) |
Country |
VarChar2(10) |
ContactNumber |
Number(12) |
Pincode |
Number(6) |
|
CalendarDimension |
NAME |
DataType |
Cal_code(sk) |
Number(6) |
Date |
Date |
Year |
Number(6) |
Month |
Number(6) |
Day |
Number(6) |
WeekDay |
Number(6) |
Quarter |
Number(6) |
|
|
|
SalesFact |
NAME |
DataType |
Prod_code(fk) |
Number(6) |
Cust_code(fk) |
Number(6) |
Emp_code(fk) |
Number(6) |
Cal_code(fk) |
Number(6) |
QuantiySold |
Number(6) |
AmountSold |
Number(6,2) |
|
