Page 1 of 1

How about a Change Data Detection stage for all DS versions?

Posted: Thu Oct 12, 2006 6:48 pm
by jdmiceli
Hi all,

I think I've read that Parallel server has some functionality for determining data changes when no update_dt is available. It would sure be nice if this functionality existed in all versions of DS, especially for us lowly Server users :wink:

I know there is CRC stuff available, but I would think this would be a basic requirement/necessity/nicety to have available.

Bestest,

Posted: Thu Oct 12, 2006 8:10 pm
by vmcburney
Wouldn't it be great? There is also the new parallel slowly changing dimension stage in the Hawk release that lets you maintain it from a single stage. There is almost no chance of it being introduced to server jobs as this is not the future direction of the product. Server jobs will continue to be supported but I wouldn't expect any new stages.

That figures...

Posted: Thu Oct 12, 2006 8:33 pm
by jdmiceli
:evil:

Leave it to my company to buy the wrong version (wrong being relative of course).

Thanks for getting back to me so soon,

Bestest!

Re: How about a Change Data Detection stage for all DS versi

Posted: Thu Oct 12, 2006 10:06 pm
by chulett
jdmiceli wrote:I think I've read that Parallel server has some functionality for determining data changes when no update_dt is available.
Isn't that the Change Data Capture stage? From what I've heard, it uses CRC32 under the covers so more properly CDD rather than true CDC... and it's not like you couldn't do CDD in a Server job in a very similar fashion. It's just not all wrapped up in one shiny stage. :wink:

you are correct...

Posted: Fri Oct 13, 2006 9:43 am
by jdmiceli
Hi Craig,

I have not found that stage in our installation of the Server Edition. Is it available for it? I thought it was a Parallel Server/TX stage, not Server. If it is a plug-in or something, where would we find the code for it to install? Did it come with our installation discs, or do we need to purchase it separately from somewhere?

Thanks!

Posted: Fri Oct 13, 2006 10:46 am
by chulett
Sorry if my post was a little confusing. The CDC stage *is* a PX only stage, I was talking about emulating what it does under the covers in a Server job - not saying there was a Server stage equivalent.