DataGenX - Atul's Blog: transformation

Showing posts with label transformation. Show all posts

5 Tips For Better DataStage Design #15

1. Stage variable does not accept null value. Hence no null able column should be directly mapped to stage variable without null handling....

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 ...

What to use instead of "Transformer" Stage Copy Stage Use "Copy" stage instead of "Transformer" Stage fo...

Goal - Extract numeric part and alpha part from a string as below Input: Source ATUL1234 SINGH374 I23S ...

Downcase(column): This function converts all the input character to LOWER case where input can be in any case. input =...

Today, we will discuss two more datastage transformer functions - Left & Right. These two functions use to get or cut the string fro...

NULL - It is always a challenge for developers or architect while dealing with NULL in data. Every projects need some base rules to process...

Index(String, Substring, Occurrence): It will returns starting character position of substring. We can use it as a 'grep...