dbTalk Databases Forums  

How to overwrite a value in the cube

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss How to overwrite a value in the cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Karen Middleton
 
Posts: n/a

Default How to overwrite a value in the cube - 11-10-2004 , 04:37 AM






I am loading data from a staging table to a cube

The key columns in my staging table are the dimensions in the cube and
the non-key values in the staging table are the measures in the cube.

All I want is if the record in the staging table matches the current
value in the cube I want the entry in the cube to be overwritten

Key columns
===========
Month
Material
Year
Customer
Store

Non-Key Columns
===============
SalesQty
Sales$


Can any of you kindly share how this can be done most efficiently as I
would have more than 2 million records in the staging table and about
3 mill records in the cube at any point of time.

Thanks
Karen

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.