With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
CREATE TABLE [dbo].[DIM_PRODUCT]( [product_id] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL, [item_category] varchar(4) NULL, [variety] varchar(2) NULL, [variety_short] varchar(15) NULL, [commodity] varchar(2) NULL, [commodity_short] varchar(4) NULL, [lot] varchar(3) NULL, [deal] varchar(3) NULL, [exporter] varchar(6) NULL, )
CREATE TABLE [dbo].[FACT_SALES]( [fk_product_id] int NOT NULL, [2LYR_volume] money NULL, [qe_fob] money NULL, [oe_freight] money NOT NULL, [oe_brokerage] money NOT NULL, [oe_other] money NOT NULL, [tt_fob] money NOT NULL, [net_fob] money NOT NULL, [average_gross] money NOT NULL, [total_income] money NOT NULL, [total_revenue] money NOT NULL, [accrued_income] money NOT NULL, ) ALTER TABLE FACT_SALES ADD CONSTRAINT FK_DimProduct FOREIGN KEY (fk_product_id) REFERENCES DIM_PRODUCT(product_id) GO
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.