Home | Contact Us | Sitemap
DWHlabs provides Data Warehouse education services.This web portal is very useful to the Database professionals,
Data Warehouse professionals, UNIX professionals etc.,
  About Us Advertise Support us Tell your Fren Testimonial Contact Us  
 
 
Please help us continue development of this website and it's services!
 
 

 

 
PROJECT LAB - S PROJECT & CASE STUDY
     
Sales | Banking | Health Care | Insurance | Telecom ...  
S PROJECT
CASE STUDY
Sponsered Links
 
 

S PROJECT - Sales

PROJECT 1
Tables
8
  Dimension Table
4
  Fact Table
1
 
   
 
Continue

STEP 1
This are the source tables which maintained in Database system.First you have to create this tables in your Database and insert few sample records.
Customer 1
Employee 2
Orders 3
Products 4
Category 5
Shipping 6
Suppliers 7
OrderDesc 8


STEP 2
Now in this section you will find all the attributes presented in the Source Tables.
Customer
CustomerID
CustomerName
Company
Address
City
State
Country
ContactNumber
Pincode
Employee
EmployeeID
FirstName
LastName
BirthDate
HireDate
Address
City
State
Country
Pincode
HomeNumber
Order
OrderID
CustomerID
EmployeeID
OrderDate
ShippedDate
ShipName
ShipAddress
ShipCity
ShipState
ShipPincode
ShipCountry
ShipPhone
Products
ProductID
ProductName
SupplierID
CategoryID
UnitPrice
UnitsOrder
UnitsStock
Category
CategoryID
CategoryName
CategoryDesc
Photo
Shipping
ShipperID
ShipperName
ShipperPhone
Suppliers
SupplierID
SuplierCompany
SupplierName
Address
City
State
Country
Pincode
HomeNumber
OrderDesc
OrderID
ProductID
UnitProce
Quantity
 
Continue
Please send your feedback Click Here .
Share your Project knowledge Click Here .
You are watching DWHlabs "Small Projects to gain Real time Knowledge"


 
DWH 3Colors
CERTIFICATION GUIDE
DATA DICTIONARY
ALL ARTICLES
   
Data Warehouse Lab

- ETL TOOL
INFORMATICA
OTHER TOOLS

- REPORTING TOOL
BUSINESS OBJECTS
OTHER TOOLS

Database Lab

- ORACLE
SQL
PL/SQL

- DB2
OTHER TOOLS

Unix Lab

Project Lab

DWH Schools

Books Store



 
  About Us Advertise Support us Tell your Fren Testimonial Contact Us  
© 2008 DWHlabs
Privacy Policy | Terms & Conditions