Groups | Blog | Home
all groups > sql server data warehouse > february 2004 >

sql server data warehouse : simple incremental update.


jr
2/12/2004 11:53:05 AM
I would like to incrementally update a cube but I am finding it some what
difficult. i would like to include the UID as a dimension and then be able
to "get the max(uid) from the cube" and then insert only rows from the fact
table that have a greater UID. Can anyone recommend how to do this or
another way to do this. I need to be able to automate the process and i was
hoping for a not so cumbersome solution.

Thanks,
j

jr
2/12/2004 1:36:40 PM
AAAHAAAA! I found a great article on specifically what I needed. Here is a
link if anyone else is interested.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8030

[quoted text, click to view]

AddThis Social Bookmark Button