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

Share On Facebook ! Share On Google Buzz ! Share On Digg ! Share On LinkedIn ! Post To Blogger ! Share On StumbleUpon ! Share On Friend Feed ! Share On MySpace ! Share On Yahoo Buzz ! Share On Google Reader ! Google Bookmark ! Send An Email ! Blog Feed !

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;

Read more »

Share On Facebook ! Share On Google Buzz ! Share On Digg ! Share On LinkedIn ! Post To Blogger ! Share On StumbleUpon ! Share On Friend Feed ! Share On MySpace ! Share On Yahoo Buzz ! Share On Google Reader ! Google Bookmark ! Send An Email ! Blog Feed !