DataStage Scenario #9 - Add Header & Trailer
Atul Singh
November 09, 2015
Scenario: Design a job to add Header and Trailer to input data. Example Input: Atul Neeraj Anita A...
Monday, November 9, 2015
Monday, November 2, 2015
5 Tips For Better DataStage Design #4
Atul Singh
November 02, 2015
1) While using AsInteger() function in datastage transformer always trim the imput column before passing it to function because if there a...
Friday, October 30, 2015
UpCase and DownCase String Function : DataStage Transformation
Atul Singh
October 30, 2015
Downcase(column): This function converts all the input character to LOWER case where input can be in any case. input =...
Wednesday, October 28, 2015
Left and Right String Function - DataStage Transformation
Atul Singh
October 28, 2015
Today, we will discuss two more datastage transformer functions - Left & Right. These two functions use to get or cut the string fro...
Tuesday, October 27, 2015
5 Tips For Better DataStage Design #3
Atul Singh
October 27, 2015
• Stage Variables allow you to hold data from a previous record when the next record, allowing you to compare between previous and current...
