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...
Tuesday, September 27, 2016
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...
Monday, August 8, 2016
ETL Strategy #2
Atul Singh
August 08, 2016
Continued...... ETL Strategy #1 Delta from Sources extracted by Timestamp This project will use the Timestamp to capture the deltas f...
Wednesday, August 3, 2016
#3 How to Copy DataSet from One Server to Another Server
Atul Singh
August 03, 2016
This post is third and last of How to Copy DataSet from One Server to Another Server Series We have generated a populated a dataset and i...
Monday, August 1, 2016
#2 How to Copy DataSet from One Server to Another Server
Atul Singh
August 01, 2016
This post is second part of How to Copy DataSet from One Server to Another Server Continue....... After generating the dummy dataset,...
Saturday, July 30, 2016
#1 How to Copy DataSet from One Server to Another Server
Atul Singh
July 30, 2016
Hi Guys... I've been asked so many times that how can we move/copy one dataset from one server to another So here is the way which I ...
Thursday, July 28, 2016
Algorithm Books
Atul Singh
July 28, 2016
If you dont have the dropbox account, create from here - https://db.tt/H5VKcNA0 Algorithm Design and Applications [Michael T. Goodrich a...
Thursday, July 21, 2016
DataStage job got Queued
Atul Singh
July 21, 2016
Today, when I was working on my DEV server ( DS V11.5), the very first time I have faced this 'job queued' status so I waited for ...
Wednesday, July 20, 2016
DBMS Books
Atul Singh
July 20, 2016
If you dont have the dropbox account, create from here - https://db.tt/H5VKcNA0 Database System Concepts 6E - Korth Book ...
Monday, July 18, 2016
ETL Strategy #1
Atul Singh
July 18, 2016
The ETL Load will be designed to extract data from all the required Data Sources. The data to feed the Next Gen BI Database will have to b...
Friday, June 24, 2016
DataStage Quiz #2
Atul Singh
June 24, 2016
Loading... If you are unable to see your result, Kindly wait for 5 min then click here - https://goo.gl/tFtU7o If you need more quiz...
Tuesday, June 21, 2016
DataStage Quiz #1
Atul Singh
June 21, 2016
Loading... If you are unable to see your result, Kindly wait for 5 min then click here - https://goo.gl/tFtU7o If you need more qu...
Wednesday, June 15, 2016
5 Tips For Better DataStage Design #14
Atul Singh
June 15, 2016
1. The use of Lookup stage depends upon the volume of data.Sparse lookup type should be used when primary input data volume is small.If th...
Tuesday, June 14, 2016
Python Points #14 - Code a childhood game
Atul Singh
June 14, 2016
Level : Intermediate Try to code this famous childhood game played in india, known as "Raja, Mantri, Chor, Sipahi", in python ...
Tuesday, June 7, 2016
Tuning SQL Statement #4
Atul Singh
June 07, 2016
Using Functions in Queries When using functions in SQL statements it is best to keep the functions away from any columns involving index m...
Tuesday, May 31, 2016
Python Points #13 - Comprehensions
Atul Singh
May 31, 2016
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.go...
Sunday, May 29, 2016
Python Points - Assignments
Atul Singh
May 29, 2016
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.goo...
