5 Tips For Better DataStage Design #18
Atul Singh
December 04, 2020
1. Use Database Connector Stages wherever possible - Older “Enterprise” stages must not be used - ODBC stages must not be used whe...
Showing posts with label Parameter. Show all posts
Showing posts with label Parameter. Show all posts
Friday, December 4, 2020
Tuesday, September 4, 2018
Create Alias Command with Parameter in Linux
Atul Singh
September 04, 2018
"Alias" - A shortcut for a command or set of commands Linux OS provides the facility to have alias command to keep the long a...
Saturday, November 18, 2017
Get Job Parameters for all DataStage Job
Atul Singh
November 18, 2017
Feels awesome while writing this post after 7 week, In this post I am going to share a script which will fetch the job parameters for all t...
Sunday, November 20, 2016
Reading DSParam - datastage parameter file
Atul Singh
November 20, 2016
I am sharing a utility which can help you to read DSParam file which holds all the environmental datastage parameters. Utility to view c...
Wednesday, April 13, 2016
ETL Code Review Checklist
Atul Singh
April 13, 2016
Guideline Design jobs for restartability/ if not designed then what is the reason ? Do not follow Sequential File s...
Monday, February 15, 2016
5 Tips For Better DataStage Design #9
Unknown
February 15, 2016
#1. Always save the metadata (for source, target or lookup definitions) in the repository to ensure re-usability and consistency. #2. M...
Wednesday, December 23, 2015
5 Tips For Better DataStage Design #6
Atul Singh
December 23, 2015
#1. If you are using a copy or a filter stage either immediately after or immediately before a transformer stage, you are reducing the eff...
Monday, November 16, 2015
List DataStage jobs which used this Parameter
Atul Singh
November 16, 2015
Open the DataStage Administrator Client Click on the Projects tab and select the project you would like to generate a list for. ...
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...
