5 Tips For Better DataStage Design #15
Atul Singh
August 22, 2016
1. Stage variable does not accept null value. Hence no null able column should be directly mapped to stage variable without null handling....
Showing posts with label transformation. Show all posts
Showing posts with label transformation. Show all posts
Monday, 22 August 2016
Sunday, 10 April 2016
5 Tips For Better DataStage Design #12
Atul Singh
April 10, 2016
1. Minimum number of sort stages should be use in a datastage job. “Don’t sort if previously sorted” in sort Stage, this option should be ...
Tuesday, 22 March 2016
Transformer Stage alternative - A Quick DataStage Recipe
Atul Singh
March 22, 2016
What to use instead of "Transformer" Stage Copy Stage Use "Copy" stage instead of "Transformer" Stage fo...
Friday, 11 December 2015
DataStage Scenario #11 - Get numeric or alphabets only
Atul Singh
December 11, 2015
Goal - Extract numeric part and alpha part from a string as below Input: Source ATUL1234 SINGH374 I23S ...
Friday, 30 October 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, 28 October 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, 20 October 2015
NULL behavior in datastage transformer
Atul Singh
October 20, 2015
NULL - It is always a challenge for developers or architect while dealing with NULL in data. Every projects need some base rules to process...
Friday, 28 August 2015
Datastage Transformer String Functions - Index
Atul Singh
August 28, 2015
Index(String, Substring, Occurrence): It will returns starting character position of substring. We can use it as a 'grep...
