Sunday, July 7, 2013

Performance Optimization technique to handle variable length data in Data Set

Posted by Venkat ♥ Duvvuri 4:02 PM, under | 4 comments

Thursday, February 14, 2013

How to replace a string in DataStage

Posted by Venkat ♥ Duvvuri 11:55 AM, under | 7 comments

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;