5 Tips For Better DataStage Design #13
Atul Singh
May 18, 2016
1. The query used in the database should be in such a way that required number of rows are fetched. Do not extract the columns which are n...
Showing posts with label #5. Show all posts
Showing posts with label #5. Show all posts
Wednesday, May 18, 2016
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 ...
Wednesday, March 23, 2016
5 Tips For Better DataStage Design #11
Unknown
March 23, 2016
When writing intermediate results that will only be shared between parallel jobs, always write to persistent data sets (using Data Set ...
Wednesday, March 2, 2016
5 Tips For Better DataStage Design #10
Atul Singh
March 02, 2016
1. Establish baselines (especially with I/O), use copy with no output 2. Avoid the use of only one flow for tuning/performance testing. P...
Monday, February 1, 2016
5 Tips For Better DataStage Design #8
Atul Singh
February 01, 2016
#1. Templates have to be created to enhance reusability and enforce coding standard. Jobs should be created using templates. #2. The temp...
Wednesday, January 27, 2016
Python Points #8 - Dictionary
Atul Singh
January 27, 2016
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.googl...
Monday, January 11, 2016
Python Points #6 - Strings
Atul Singh
January 11, 2016
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.goog...
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...
Thursday, November 19, 2015
5 Tips For Better DataStage Design #5
Atul Singh
November 19, 2015
#1. Use the Data Set Management utility, which is available in the Tools menu of the DataStage Designer or the DataStage Manager, to exami...
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...
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...
Tuesday, October 13, 2015
5 Tips for better DataStage Design & Administration #2
Atul Singh
October 13, 2015
1. In a DataStage server environment with more than one version of DataStage installed in the dsjob command you must specify the server nam...
Friday, September 25, 2015
5 Tips for better DataStage Design #1
Atul Singh
September 25, 2015
01. Always try to complete the requirement first, Don't spoil your time to develop an optimized job which is practically useless unti...
