No need to add duplicate dim. tables (aka 'alias' in SQ2K), using views works better in my experience

I liked the article pace, some of us never got the command line experience...

Keep them coming!

Research is what I'm doing when I don't know what I'm doing.

-- Wernher Von Braun --

Self knowledge is always bad news    

-- Zorba the Greek   --

A quick fix would be to alter the destination table in a SQL statement, to

set the [rec_id] column: IDENTITY(1,1) NOT NULL programatically. You

can reset it back after copying the records....

My best experience was with Proclarity - they have english, german, frech, italian, etc versions - also a solid product history and masters of scalability.

I'm (still) waiting for new material regarding UDM from Microsoft ...

Apart from Paul Sanders' old articles there is nothing on this topic. My understanding is that UDM is constructed...

I would suggest dropping and recreating the private dim. good luck

You want to track the responses to your marketing campaigns, and you want to specifically

know who responded to them - you may consider:

- the initial state of the campaigns (list of sent...