DSXchange

See this post. You can also look at thisone.

Mini batch jobs which extract data from SalesForce fail intermittently with "Connection refused" message. Please share your thoughts/experiences on this. Complete error text is sfdc_extract failed. main_program: Fatal Error: Information: error code: 8 error message: ; nested exception is: ...

Only workaround for this issue is to perform some operation on every column in the upstream transformer (e.g. append an empty string to a string column, add 0 to a numeric column) rather than mapping directly. During version 8.5, this issue was addressed in JR47138, but it is reoccurring in DataStag...

We have also faced situation similar to yours ... after running successfully for months, status of a production job had also flipped to "not compiled", but in the project library we could see the output files/directories from compilation. Further investigation did not yield much. Though wh...

While performing SFDC sparse lookup, the position of the lookup column in the input link is entered in SOQL's WHERE clause (counting from zero) e.g. ''{3}'' for 4th column. If any column is modified/manipulated in a transformer (prior to SFDC stage) then modified column(s) move up in internal output...

On an IIS server installed on Linux/Unix, one can import (but not export) dsx files by leveraging DSXImportService.sh script. See this technote for details.

Go for 11.5 fp1 and apply all the available rollups.

In our shop, Dastage is installed in two-server, active-passive topology. Late last night, the primary server failed and (as anticipated) all the running jobs failed, subsequently DataStage came up on the secondary server. Operators were able to restart all the failed jobs, but for one which was stu...

As per latest communication from IBM, Oracle Connector developer has confirmed this is a defect and opened APAR JR57101. They will be fixing this in a later release.

U, Did you get an answer to your question? How did you purge these files?

Also the Subject "Datastage" is quite ambiguous. Can you make it more relevant to the query.

Patch JR55886 is now available to balance compute node utilization when Oracle partitions out number compute nodes.

It is difficult to guess the requirement and answer this question on basis of a single example. What is the requirement in words? What are source and target data types?

Balanced optimization is a feature and can be managed thru iisAdmin. Give following Unix command to check if Balanced Optimization is not already ON <IS_install_path>/ASBServer/iisAdmin.sh -display -key com.ibm.iis.datastage.license.* Look for com.ibm.iis.datastage.license.feature.BAL_OPT=1. If you ...

While I cannot comment of various grid resource management software products, I will strongly advise using one of the IBM products. During DataStage upgrade, we used a supporting software from a non-IBM vendor. Subsequently integration with DataStage was challenging as documentation is based on IBM ...