you have to have outlook or some mail client installed on the server then configure db mail. then build a job that checks for blocks every x minutes and emails...

would this be including the pk...

Ok i understand. Think im getting my head round this after a bit of confusion. CDC will only provide a performance improvement at the extract stage, once the changed rows...

Koen Verbeeck (1/13/2015)

---

ps_vbdev (1/13/2015)

---

Ok so your doing the comparison in your staging area. but you would still have to do a full extract from source db (bulk Insert?) to get...

Ok so your doing the comparison in your staging area. but you would still have to do a full extract from source db (bulk Insert?) to get the source tables...

you cant seem to hit views. my only thoughts are to somehow build the sql onto the system tables that cdc creates to track the changes but not sure if...

Thanks Koen

yes ive got this far with the database and ssis packages. CDC seems good for replicating changes on table for table bases as you would for incremental loading and...

Hi

Thanks for the reply. When i say creating etl packages im really talking about complex ones with lookups, conditional splits derived colums inserts and updates etc. This business process...

Ive been reading a bit further into my kmibal book. in this scenario could the color and size be considered as degenerate dimension ie. not bother have them in the...

ok Koen, ill investigate further, thanks for the help mate..

I know, i know its crazy, the problem is the colors relay. you see designers have always been allowed to set up there own products so when they are...

Additionally

If i have one mini-dimension for both color and size this would still give about 5million combinations so could i split this further down to having two mini-dimensions, one for...

Excellent, back on track now 🙂

Cheers

Thanks Koen

I was actual reading about these but was not sure if i was on the correct path. In my case would i have a product dimension of granularity Product+designer+collection...

Thanks that works.