sql server data warehouse: Datamart -- sql server data warehouse

Re: Datamart

Reg Besseling
12/14/2004 1:29:10 PM

Ather

I only put complete / closed / posted items into my DWH unless the business
can justify why they want incomplete / incorrect data in the DWH, so i would
only transfer closed orders

Use MS- SQL as your DWH server as you get DTS (Data Transformation
Services) with it, which can be used as a lightweight ETL tool

Create some DTS packages to update your DWH at the end of each day ( or any
other viable interval) with the new closed orders

Unless you have paid for / are forced to use COGNOS look carefully at
reporting services and analysis services as your BI tools

Regards

Reg Besseling

[quoted text, click to view]

RE: Datamart

Rangarajan Suresh
12/22/2004 8:57:02 AM

Identify all the OPEN orders (order status or some other combination of
field(s) ) which will narrow the list of orders that will get affected in
your datamart. For these open orders:
(1) Delete the orders from your datamart.
(2) Re-insert the data about the open orders.

I am making an assumption that you do not have track the order status
history itself. I am also making an assumption that data about "closed"
orders does not change and/or you do not want to change them in the datamart
in any way.

Hope this helps.

Rangarajan Suresh
www.picarossolutions.com
*********************

[quoted text, click to view]

Re: Datamart

Reg Besseling
12/28/2004 9:05:21 AM

What Will happen to orders that change from open to closed ? it seems to me
that they will get "Lost" until the next full refresh

Regards

Reg Besseling

"Rangarajan Suresh" <RangarajanSuresh@discussions.microsoft.com> wrote in
message news:DC96DE91-8994-41BD-A84F-5FED65FBA3D6@microsoft.com...
[quoted text, click to view]

Re: Datamart

Rangarajan Suresh
1/3/2005 11:25:07 AM

I guess I should have also addressed the issue of "closed orders" along with
"open orders" -- The closed orders are to be loaded as inserts into the
datamart. They do not necessarily fall under the issue of "replacing"
existing open orders that may have changed in some fashion. Since we are
deleting existing open orders from the datamart, the same order will not go
into the datamart as it is no longer open.

Sorry for the confusion.

Rangarajan Suresh
www.picarossolutions.com
*********************

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server data warehouse group.