DSXchange

Yes, since in your situation there is no automatic means to do this you need to do it manually.

Vindy,

Your sequence is failing because one of the jobs that it calls, "J_Stage_PS_S_BUS_UNIT_FS_CRM " is failing.

Could you explain your question in a bit more precise way? Informatica and DataStage are both ETL products that have been competitors for many years.

Ray, your interpretation of the question makes a lot more sense. I've started using usage analysis extensively and love that functionality -- but it does require using the metadata for tables and files otherwise it does fall apart. But when it works it makes development and change tracking so much e...

Entering "I" in edit mode will switch you into input mode, and entering a <CR> on an empty input line will switch you back into edit mode.

Version Control will include the date/time promoted information in the long text description field of a job, so that won't help you. I would suggest that you manually enter a fixed-format text that you can parse out of the text, such as "Job Created on yyyy-mm-dd" to store that information.

Since access to data is determined by a userid (an OS one or a database one) I don't think it is possible - since a user needs to read the data in order to run a job it is impossible to keep that user from reading the data outside of DS. If you implement a system using parameters and computed userid...

Abby,

what stage are you using to write to which database and what is the warning message you are getting?

If you have a UNIX system you can never guarantee equal usage. I don't know how you differentiate or define your "EDW" and "DWH" - are they different DataSTage projects? Assuming your jobs are CPU bound (which isn't always the case) then if you start n processes they will each get 1/nth of the resou...

You should enable inter-process row buffering; that is almost the same as using an explicit IPC stage. The buffer size does not normally affect the speed and shouldn't be changed. The buffer size should be set so that it is adequately large for enough rows of data to overcome temporary differences i...

the "dsjob" command is on your Windows server system - but you haven't added it to your path - just do a search of your server to find the dsjob.exe (you will need to specify a number of command line options to start a job, but they are listed when you call up "dsjob" and are also described in your ...

Great - thanks for the update!

In option (1) enter "DOS" to get a dos cmd shell, then you can run the "dsjob" command with the options you require. In option(2) you are attempting to create a DataStage account (not a project) in D:\ and if you choose one of the 5 it will create a number of files that you really don't want! Please...

Somaraju,

I'm glad my comment helped you find your error! Could you post what it was, so that someone using the search facility with the same issue can see the resolution?

The site I am at has numerous concurrent accesses to DataStage 7.1 and 7.5 through Citrix without problems (well, without your type of problems). I think that it is a problem with your Citrix implementation or installation.