DSXchange

Ok, that's a good idea, Thanks for your help. I'll close this topic

No one at my site has any recollection of these so I'm under the impression they came with 7.5

These are located under Routines / DS / SCD and under Transforms / SCD

Does any one know how to use the datastage routine DSSCD and/or the SCD2 Transform. I cant seem to find any documentation on these. I'm trying to find some examples on how to set up one that uses slowing changing dimensions to handle changes to our customer dimension.


Thanks

Thanks, would have an example of how this would be coded? I moved the -server -user and -password to a file and specified

dsjob -file LOGIN.TXT -run <project> <job>

but it's failing to locate the server.

Looking for some examples on how to set up a dsjob command line. I have the following command line but would like to find out a way to hide the userid and password information.

dsjob -server <server> -user <username> -password <password> -run <project> <job>