Get File Size in Transformer Stage - DataStage
Atul Singh
December 16, 2021
I have seen lot of cases where I have to get the file size or no of lines in file or any Linux command output in between job flow. The easy ...
Showing posts with label transformer. Show all posts
Showing posts with label transformer. Show all posts
Thursday, December 16, 2021
Wednesday, September 13, 2017
Evaluation Sequence in Transformer Stage - A Quick DataStage Recipe
Atul Singh
September 13, 2017
Recipe: What is evaluation sequence in Transformer Stage Or Order of Stage & Loop Variable and Derivations Ingredients: 1. Tr...
Wednesday, July 5, 2017
Conditionally Aborting Jobs with Transformer Stage
Atul Singh
July 05, 2017
How to develop a job which will stop processing when FROM_DATE and TO_DATE is equal in data? Or I want to abort the job when reject row co...
Friday, May 6, 2016
DS Fatal Error: Destination "APT_TRinput0Rec0" is already bound
Atul Singh
May 06, 2016
Fatal Error: Destination "APT_TRinput0Rec0" is already bound - Transformer Stage Error Solutions: * Check if the output sta...
Tuesday, May 3, 2016
Otherwise Constraint - A Quick DataStage Recipe
Atul Singh
May 03, 2016
Recipe: How to use "Otherwise" constraint in Transformer Stage How To: To use "Otherwise" constraint in Trans...
Sunday, April 10, 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, March 22, 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, December 11, 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 ...
Wednesday, October 21, 2015
DataStage Scenario #8 - Populate date between given two
Atul Singh
October 21, 2015
Scenario : Design a job with 2 job parameters - 1. Start Date ( DD-MM-YYYY ) 2. End Date ( DD-MM-YYYY ) Read the parameter a...
Tuesday, October 20, 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...
Tuesday, September 29, 2015
DataStage Scenario #6 - Populate 'Not Found'
Atul Singh
September 29, 2015
Scenario: Design a job which read a flat file and populate the output as NOT FOUND which is not available in the other file. Exa...
Monday, September 14, 2015
DataStage Scenario #2 - Find Palindrome Number
Atul Singh
September 14, 2015
Develop a datastage job to identify whether input data is a palindrome number or not, If it is, need to print the output as below - ...
Friday, August 28, 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...
