Performance Optimization technique to handle variable length data in Data Set

How to replace a string in DataStage

I have seen several web sites which are explaining most of the things on DataStage, but I have not seen easiest way to replace a string by using DataStage functionality without using Ereplace Function.

Field Name: SERVICE

Requirement: If the service description contains the word "Functional", then replace the word with "Technical".

Source Service Desc: My Functional Service for you...!!!

Expected Target Service Desc: My Technical Service for you...!!!


Logic to get the output as per the specified requirement;

New features and changes for IBM InfoSphere Information Server, Version 8.7

New features and changes were introduced for IBM® InfoSphere® Information Server, Version 8.7 along with documentation updates. The new and changed features and documentation updates are described in the following sections.

Table of contents

InfoSphere Information Server, Version 8.7, new features and changes:

• Common capabilities across the InfoSphere Information Server suite
  • Administering
  • Connecting to external sources

Bottom

The tsort operator

WebSphere DataStage provides the sort operator, tsort that you can use to sort the records of a data set. The tsort operator can run as either a sequential or a parallel operator. The execution mode of the tsort operator determines its action:

• Sequential mode: The tsort operator executes on a single processing node to sort an entire data set.