Ingeniero En Informatica

Estimados Compañeros: GAYS

Deben crear las:
* 4 Dimensiones (Dim_Tiempo, Dim_Empleado, DIm_Cliente, Dim_Productos
* 1 Tabla de hechos (Fac_Ventas).

Querys para crear las Dimensiones:1) Dimensión Tiempo:

Y en formato texto si quieren copiar pegar:
CREATE VIEW Dim_Tiempo
AS
SELECT DISTINCT TOP (100) PERCENT OrderDate AS tiempo_key, CAST(MONTH(OrderDate) AS varchar) + '-' +CAST(YEAR(OrderDate) AS varchar) AS MesAño, MONTH(OrderDate) AS mes, YEAR(OrderDate) AS año,
DATEPART(week, OrderDate) AS semana, DATEPART(weekday, OrderDate) AS diasemana, DATEPART(quarter,OrderDate) AS cuatrimestre,
CASE WHEN MONTH(OrderDate) >= '1' AND MONTH(OrderDate) <= '4' THEN '1'
ELSE CASE WHEN MONTH(OrderDate) >= '5' AND MONTH(OrderDate) <= '8' THEN '2' ELSE '3'END ENDAS Trimestre, CASE WHEN MONTH(OrderDate) >= '1' AND MONTH(OrderDate) <= '6' THEN '1' ELSE '2' END AS Semestre
FROM dbo.Orders AS a ORDER BY diasemana

2) Dimension Empleados:

Y enformato texto si quieren copiar pegar:
CREATE VIEW Dim_Empleados AS SELECT EmployeeID AS empleado_key, FirstName + ' ' + LastName AS Nombre_Cliente, City AS Ciudad, Region as Region, Country ASPais FROM dbo.Employees

3) Dimension Clientes:

Y en formato texto si quieren copiar pegar:
CREATE VIEW Dim_Cliente AS SELECT CustomerID AS cliente_key, CompanyName AS Nombre_Cliente, CityAS Ciudad, Country AS Pais
FROM dbo.Customers

4) Dim Productos:

Y en formato texto si quieren copiar pegar:

CREATE VIEW [dbo].[Dim_Productos] AS SELECT Products.ProductID asproducto_key, Products.ProductName as Nombre_Producto, Categories.CategoryName as Categoria, Suppliers.CompanyName as Vendedor
FROM dbo.Products INNER JOIN dbo.Suppliers ON (Products.SupplierID =dbo.Suppliers.SupplierID) INNER JOIN dbo.Categories O (dbo.Products.CategoryID = dbo.Categories.CategoryID)

Querys para crear la Tabla de Hechos:
Ahora no crearemos una vista sino vamos a crear una tabla,...