NULL Handling in Sequential File Stage
Atul Singh
April 04, 2017
DataStage has a mechanism for denoting NULL field values. It is slightly different in server and parallel jobs. In the sequential file sta...
Tuesday, April 4, 2017
Saturday, April 1, 2017
Get Over Running DataStage Job Details #iLoveScripting
Atul Singh
April 01, 2017
With the script below, we will get a list of jobs which are taking more time to complete than last run time. By some tweaks, we can use thi...
Saturday, March 25, 2017
Check if Python Pandas DataFrame Column is having NaN or NULL
Atul Singh
March 25, 2017
Before implementing any algorithm on the given data, It is a best practice to explore it first so that you can get an idea about the data. ...
Wednesday, March 22, 2017
Measures of Data Spread in Stats
Atul Singh
March 22, 2017
What do we mean by SPREAD? - The measures which can tell us the variability of a dataset, width, average distribution falls into this categ...
Tuesday, March 21, 2017
The Three M in Statis : Measures of Center
Atul Singh
March 21, 2017
In Statistics, 3M summary is very important as it tells a lot about data distribution. These Ms are - Mean, Median and Mode Mean - Averag...
Summary Statistics in Data Analysis
Atul Singh
March 21, 2017
Summary statistics are numbers that summarize properties of the data. i.e - Mean, Spread, tendency etc. We will see each one by one. Let...
Sunday, March 19, 2017
5 Number Summary - Statistics Basics
Atul Singh
March 19, 2017
What is 5 no summary? 5 no summary is an statistical measure to get the idea about the data tendency. It includes : 1. Minimum 2. ...
Wednesday, March 15, 2017
JDBC DSN Configuration in IIB (WMB)
Atul Singh
March 15, 2017
1. mqsilist : 2. mqsireportproperties <BROKER> -c JDBCProviders -a -o AllReportableEntityNames mqsireportproperties TESTNODE_...
Wednesday, March 8, 2017
Perl Script to get content difference of a file #iLoveScripting
Atul Singh
March 08, 2017
This Perl script will help you to get the content difference of a file available in two directories. Usage: diffmany.pl filename dir1 d...
Sunday, March 5, 2017
How to get DataStage Project Settings
Atul Singh
March 05, 2017
DSListProjectSettings.bat is used to report all available settings of existing projects. USAGE: DSListProjectSettings <SERVER> <...
