Criei um DW para fins de aprendizagem do BD Adventure Works, o problema é que não estou conseguindo carregar a tabela fato.
Dúvidas: 1 – Preciso trazer a PK do BD OLTP sempre? 2 – Como faria a carga na tebela Fato
Meu DW está dessa maneira:
CREATE TABLE DimAddress ( SK_Address INT NOT NULL IDENTITY PRIMARY KEY, City VARCHAR(30), StateProvince VARCHAR(50), CountryRegion VARCHAR(50) ); CREATE TABLE DimEmployee ( SK_Employee INT NOT NULL IDENTITY PRIMARY KEY, JobTitle VARCHAR(50), BirthDate DATE, MaritalStatus CHAR(1), Gender CHAR(1), HireDate DATE, VactionHours SMALLINT ); CREATE TABLE DimDepartment ( SK_Department INT NOT NULL IDENTITY PRIMARY KEY, Name VARCHAR(50), GroupName VARCHAR(50) ); CREATE TABLE DimTime ( SK_Time INT NOT NULL IDENTITY PRIMARY KEY, Date DATE, Month INT, Year INT, Half INT, Quarter INT ); CREATE TABLE FactHumanResources ( SK_Address INT NOT NULL, SK_Employee INT NOT NULL, SK_Department INT NOT NULL, SK_Time INT NOT NULL, Amount INT, PRIMARY KEY (SK_Address, SK_Employee, SK_Department, SK_Time) ); 