DSXchange

IBM has informed us ... We should prioritize the patch JR47138 implementation based on the work effort since its not a simple fix and might need some design changes so, it might be considered for the next release of IS. We will workaround this issue by either: - Avoiding upstream transformer from SF...

I meant the duration of the installation of entire IS with most pre-requisites are taken care (though there seems to be a lot) Installation/configuration of DataStage involves four steps. 1. Install the prerequisite software required. 2. Configuring prerequisite software and OS environment for Info...

What will be the topology?

By installation do you mean length of the entire projects or simply installation of software (after all the prerequisites are done)?

Carriage return => Char(13). Can you try running following derivation on FREE_TEXT_FIELD in the transformer.

Could there be multiple records with same key values in incoming data?

What are values of 'Auto Commit mode', 'Array size', 'Transaction record count'?

Test after changing array size to 1.

What is your source?

What is the RAM allocation on the client machine? Are DataStage Prod and Dev server located in same Data center?

Text states

topdsx wrote:Look for error messages in the preceding output.

What are the error messages in the preceding output?

You can also look in database.properties file. Location of this file varies by version, it may be ... /opt/IBM/InformationServer/ASBServer/bin/sql/ or /opt/IBM/InformationServer/ASBServer/conf/.

Monitoring data captured in DSODB can be configured in DSODBConfig.cfg file. (Default directory: /opt/IBM/InformationServer/Server/DSODB/DSODBConfig.cfg) Add following entry in DSODBConfig.cfg (ideally in "Job Log Events" section) to capture "Summary of sequence run" CaptureLog=I...

Can you please share your thoughts/experiences on loading Azure Redis Cache using DataStage.

It will be ideal to fully qualify the table name. However, if that is not desirable/possible, then followthis link to see various options for handling unqualified table names.

I have used following query to research a similar issue. Transformer function can be parsed from text in last column i.e."expression_xmeta" SELECT a.dsnamespace_xmeta AS Project_Nm, a.category_xmeta As Folder_Nm, a.name_xmeta AS Job_Nm, b.name_xmeta AS Stage_Nm, d.name_xmeta AS Link_Nm, e....

You can use External Source stage for solving this issue. Will you be removing header from a single file or from multiple files? If from a single file, then set value of "Source Program" to tail -n +4 <path>UKRIPR*.txt and if from multiple files, then to for i in <path>UKRIPR*.txt; do tail...

Usually yes, but OP's example has variable no of columns to be pivoted!