New Slowly Changing Dimension Job

tom_robinson · Post by **tom_robinson** » Fri Mar 05, 2004 2:43 pm

Has anyone ever used the "New Slowly Changing Dimension Job" functionality within Datastage?

The Datastage 7.0 Designer Guide displays this as an option for a way to create a job when using the New Prompt. However, this option is not appearing in my installation of Datastage. Is this something that can be enabled?

Here are the list of options the documentation lists as available:
-Server job
-Mainframe job
-Parallel job
-Server Shared containers
-Parallel Shared containers
-Job Sequences
-New Data Migration Job
-New Slowly Changing Dimension Job

Here are the list of options that are displayed to me when I try to create a new job:
-New Job Sequence
-New Server Job
-New Server Shared Container
-New Job from Template
-New Template from Job

Thanks in advance for your help!

Tom

chulett · Post by **chulett** » Fri Mar 05, 2004 2:50 pm

I believe you'll find that this is for PX jobs only.

tom_robinson · Post by **tom_robinson** » Fri Mar 05, 2004 3:45 pm

I just spoke with a technical support person from Ascential who was working with a complete install of DataStage (PX included), and it wasn't visible to her either. I pointed out to her the documentation page which showed the functionality, page 3-3 (63 out of 322 in the PDF) of the Ascential DataStage Designer Guide.

I'm really curious, because I think it could greatly simplify what I'm currently working on.

Could they have included the functionality in their documentation, but not included it in their release?

Thanks,

Tom

chulett · Post by **chulett** » Fri Mar 05, 2004 4:17 pm

That could very well be. It may have gotten "pulled" or delayed to a later release due to last minute issues.

From what I heard, something like that happened to the rumored Stored Procedure Stage.

Let us know what you find out!

ray.wurlod · Post by **ray.wurlod** » Sat Mar 06, 2004 3:12 am

It's in my 7.0.1 on WinNT. However I've been having an offline exchange of private messages at ADN with someone from Ascential who says it isn't. Stay tuned...

tom_robinson · Post by **tom_robinson** » Sat May 29, 2004 4:37 am

I received word from Ascential that this functionality is only offered to their internal consultants.

chulett · Post by **chulett** » Sat May 29, 2004 6:39 am

You would think those would be the people who shouldn't need it.

datastage · Post by **datastage** » Sat May 29, 2004 6:43 pm

what's the fun of reusing predesigned components for slowly changing dimensions? They are taking all of our fun away. I wonder how well it works though, SCD theory never changes, but everyone's real life situation always seems to vary....curious if it is versatile enough to handle anyone's SCD challenge.