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,
How about a Change Data Detection stage for all DS versions?
How about a Change Data Detection stage for all DS versions?
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
That figures...
Leave it to my company to buy the wrong version (wrong being relative of course).
Thanks for getting back to me so soon,
Bestest!
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
Re: How about a Change Data Detection stage for all DS versi
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 wrote:I think I've read that Parallel server has some functionality for determining data changes when no update_dt is available.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
you are correct...
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!
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!
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"