AdventureWorks\AdventureWorksDW question

I thought that all data in AdventureWorksDW came from the OLTP AdventureWorks database. But....then I looked at DimTime table in "DW". I doubt that level of detail exists in the OLTP database.

Is it common to add new data and fields to the OLAP side that didn't exist in the OLTP side?

Pup

Dear barkingpup,

Can you plz give more details about you question ?

OLAP create time dimension based on the_date column of time dimension table, you have to select which time heirarchy you want.

|||

Hello Syed Mahmood Ali,

i think that barkingpup talked about the data in the AdventureWorks and the AdventureWorksDW. He think that AdventureWorksDW is a data mart(data warehouse) created from the AdventureWorks database which would be the OLTP. And his question is, if its the case, is it usual to add data in the data mart which are not in the OLTP. According to me, in the data mart, the data come from only the OLTP. Perhaps from different database but which set up the OLTP system. AdventureWorksDW is only an sample and the conception is quite different than AdventureWorks. So the needed data for the sample are differents too...

I hope that will answer the barkingpup's question.

|||i also gone throug adventuerwork and adventuerworkdw still doubt are adventuerwork is the only source for adventuerworkdw can anybody guide me for creating diagram for complet adventuerwokrdw datamart.|||

Hello. You build the Time dimension in SSIS(Integration Services) or in the Data Source View(by a named calculation) using TSQL Date functions on the Order or Invoice Date in the OLTP database.

One of the most useful us the TSQL Datepart function where you can derive month, quarters and years from a date column.

You will only need a single date column to build an entire time dimension.

HTH

Thomas Ivarsson