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

[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

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

Bestest,

[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.

[jdmiceli]

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

Thanks for getting back to me so soon,

Bestest!

[chulett]

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.

[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!

[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.