DSXchange

This stage is a mess if used with batchpipes option for loading data. It's way too compicated and many things go wrong while loading. Some of these issues don't even have any fixes as of now. As an example, if you have any RI constraints or FK violation during the build index phase of your load, the...

Thanks Ray.

Can someone help me in finding how DataStage manages to access datasets created in a grid environment, since the config file used to create may be different from the one that is used to access the dataset( in a different job, or in a different run) and it may or may not include the original nodes us...

I think the initial calls to the function should not be parallel, even though your jobs run in parallel at a later stage. I mean, may be giving some delay between the start ups of the jobs might solve this.

Does "hai" at the beginning of your question mean that you understand? The operating system only allows one writer at a time to a file. Given that fact, you can figure out the answer to your question. Use "DSJobInvocationId" as part of the file name, that way your job can run in...

Test button is enabled only if you logged in as an administrator.
The user -id to schedule the jobs must belong to a local adminstrators group.

Log on to the DataStage server. Choose Start --> Settings-->
Control Panel-->Services-->Schedule.

Go to Manager--> Tools-->Run Multiple JobCompile

Thanks a lot. That's all I needed.

If you are not going to do any iterations then do nothing. The sequence automaticaly stops after the last activity.

I think you are better off exporting all your DataStage components, uninstalling version 7 and performing an 8.0.1 install and importing. This will be easier to rollback and restart if the install fails. You can put your Metadata Server (domain layer and repository) on a separate machine to your Da...

We are planning to upgrade to information server 8.0.1 from DataStage server 7.5.2. I was wondering what is the main difference between basic installtion and a Complete installation. I know that the basic installation just upgrades all the components in the currrent location, so that we don't have t...

Check if both your source and hashed file have the same set of keys.

Usage analysis of table definitions could also be helpful if you have used the table definitions to load the columns in your files / tables.

You cannot do that . Use wait for file stage instead.