DataStage Partitioning #1
Atul Singh
November 09, 2016
Partitioning mechanism divides a portion of data into smaller segments, which is then processed independently by each node in parallel. It ...
Wednesday, November 9, 2016
Monday, November 7, 2016
Modify Stage - Drop Columns
Atul Singh
November 07, 2016
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.goo...
Saturday, November 5, 2016
Export the jobs from DS windows client
Atul Singh
November 05, 2016
Datastage jobs Export/Import are occasional activity (Deployment time :-)) for a developer But it becomes very tedious if the job list are...
Wednesday, October 19, 2016
Jenkins with Windows #3
Atul Singh
October 19, 2016
Continuing my last posts ( Jenkins with Windows #1 & Jenkins with Windows #2 )..I am adding some more tips or solution with Jenkins in...
Tuesday, October 18, 2016
Jenkins with Windows #2
Atul Singh
October 18, 2016
In last post, we covered What is jenkins and it's benefits (http://bit.ly/2e7mNbb). Today we are going to cover it's installtion o...
Sunday, October 16, 2016
Jenkins with Windows #1
Atul Singh
October 16, 2016
One of my team member is assigned to install and configure "jenkins" on our server so out of curiosity, I asked what is this now ...
Wednesday, October 12, 2016
Script to Auto Compress the System Log Files
Atul Singh
October 12, 2016
This Script is originally written by " Andy Welter " to compress the linux system log files. I have modified it to work better. Y...
Tuesday, October 11, 2016
5 Tips For Better DataStage Design #16
Atul Singh
October 11, 2016
1. Use 4-node configuration file for unit testing/system testing the job. 2. If there are multiple jobs to be run for the same module. Arc...
Monday, October 10, 2016
MarkDown Cheat Sheet
Atul Singh
October 10, 2016
If you are unable to see, You can download from here - https://goo.gl/In52dQ Like the below page to get update https:/...
Saturday, October 8, 2016
#2 DataStage Solutions to Common Warnings/Error - Null Handling
Atul Singh
October 08, 2016
Warnings/Errors Related to Null Handling - 1.1 When checking operator: When binding output interface field “XXXXX” to field “XXXX...
Thursday, October 6, 2016
Difference between IBM CDC and CDD
Atul Singh
October 06, 2016
Now a days I am busy with an another IBM tool called CDC - Change Data Capture, now knows as IBM Infosphere Data Replication. IBM CDC rep...
Tuesday, September 27, 2016
DS_PXDEBUG - DataStage Parallel Debugging Variable
Atul Singh
September 27, 2016
* Controlled with an environment variable, not exposed on GUI. DS_PXDEBUG set to activate feature (e.g. DS_PXDEBUG=1) * Warning logg...
Monday, September 19, 2016
#1 DataStage Solutions to Common Warnings/Errors - Datatype
Atul Singh
September 19, 2016
Warnings/Errors Related to Datatype This Warnings/Errors described in this section are based on Data type like data type mismatch, Column...
Monday, September 12, 2016
Python Points #15 - Exceptions
Atul Singh
September 12, 2016
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.go...
Monday, August 29, 2016
Modify Stage - What's been promised
Atul Singh
August 29, 2016
Modify stage, one of the most un-used stage in DataStage but very useful in terms of performance tuning. It is advisable to Developers not ...
Sunday, August 21, 2016
5 Tips For Better DataStage Design #15
Atul Singh
August 21, 2016
1. Stage variable does not accept null value. Hence no null able column should be directly mapped to stage variable without null handling....
Sunday, August 14, 2016
NULL behaviour in Oracle
Atul Singh
August 14, 2016
NULL, as known in SQL, a special marker and keyword indicating that something has no value. A value of NULL is different from an empty or z...
