DSXchange

We are looking for a solution to convert a hexadecimal string to a decimal within Datastage. The source system provides an 8 character string. Input: 01FEE741 Output: 33.4825610 Input: FAD4F96B Output: -86.7058160 We have used SQL Server functions to convert the string but would like to eliminate th...

Thanks for the feedback. I will research the server job approach. And under the assumption the advice is solid , consider the issue resolved.

Thank you for your response. I did manage to create a job sequence that called a parallel job to output the list of employees to a sequential file. The job sequence then read the file content and looped through both the file list and a date range calling the parallel job that then executes a web ser...

I have created a parallel job that retrieves a list of employee numbers from a table. The resulting rows are passed to a transformer stage. The TSF stage generates additional rows for each employee based on a date range. The TSF also adds information needed to call a web service to each row. The out...