DSXchange

Hi, IBM provides 2 training courses for DataStage. 1. DataStage Essentials 2. Advanced DataStage Both of these courses would help you get to the Certification level. But if you feel these courses are expensive, I would suggest that you google for DataStage documention and also check for IBM Redbooks...

Hi Raja, Iam not aware of any project level setting for setting the max sessions. But you still have to provide so many other information in the multiload stage whcih would be different for each job. So I don't see any advantage of setting the max sessions at the project level even if that setting i...

Ray and Vincent, Thanks for your inputs.

Vincent, I already googled your blog post - an excellent blog for migration. But not sure if the Migration Assistant would be robust and what if we would run into problems using this new tool.

Thanks once again - Rich

Hi Ray,

Did you mean - "Directly is OK" for 7.1 to 8.5 or for 7.5 to 8.5. From whatever I investigated so far the migration from 7.1 to 8.5 happens in 2 stages - 7.1 to 7.5.3 to 8.x. Pls advice.

TIA
--Rich

Hi All, We are planning to migrate from DataStage 7.1 to DataStage 8.5 on IS. I have already searched the forum and also googled to find some good inputs and materials. But I want to know for sure if the migration can happen directly from 7.1 to 8.5 or if there would be an intermediate migration to ...

Hi, Where did you find this error? In the Director or in the report file. Always check the report file for Multiload errors. Also when you re-start the job you have to drop all the temp tables that would be created for each multiload session like log, UV, err and work tables. Then issue the command ...

Hi,

If you want to avoid these warnings, you can do the substring functionality in a transformer and then do a join.

HTH
--Rich

Hi,

Are you using the same credentials for both Teradata SQL Assistant and the ODBC stage? Did you try with any other Teradata stage other than the ODBC stage?

--Rich

Hi,

Try using $APT_EXPORT_FLUSH_COUNT environment variable in your job. This allows for moving the data from the buffer to the file.

HTH
--Rich

Hi,

Pls search for my posts on DecimalToString. Along with the DecimalToString you have to use the Field and Trim options to remove the unwanted zeros.

HTH
--Rich

Hi,

It seems to be a DB issue from the error message you are getting. Pls check if the database is available before doing the load operation.

HTH
--Rich

Hi Siva, Try to do a metadata import in DataStage for this Teradata table and you will find out that the Primary Index columns are automatically translated to Key columns in DataStage. This is because Teradata uses the Primary Index (not the Primary Key) for its data distribution, data retrieval and...

Hi Andy, What if the User is a DataStage Suite User (DataStage and QualityStage User) but is not mapped to any of the roles that are available in DataStage Administrator (1.DataStage Operator 2.DataStage Super Operator 3.DataStage Developer 4.DataStage Production Manager) then he should be able to v...

Hi,

1. Pls check this link for a list of job status codes

2. Check the job properties if it is a multi-instance job.

HTH
--Rich

Hi,

Along with the function mention the format as well.

The default format would be yyyy/mm/dd so when you pass the value in this format it works. But if you feed data in a different format it will not work until you mention the format in the DateToString function.

HTH
--Rich