Mathematics in Markdown
Atul Singh
September 28, 2017
From Wiki - Markdown is a lightweight markup language with plain text formatting syntax designed so that it can be converted to HTML ...
Thursday, September 28, 2017
Wednesday, September 13, 2017
Evaluation Sequence in Transformer Stage - A Quick DataStage Recipe
Atul Singh
September 13, 2017
Recipe: What is evaluation sequence in Transformer Stage Or Order of Stage & Loop Variable and Derivations Ingredients: 1. Tr...
Tuesday, September 12, 2017
A Newer Version of Jupyter Notebook - Jupyter Lab
Atul Singh
September 12, 2017
We all use Jupyter Notebook (previously known as IPython Notebook) a lot when researching on something or doing stuff on stuff :-) For tho...
Monday, September 11, 2017
Datastage Calling script in Remote Server
Atul Singh
September 11, 2017
Step 1: Setting up UNIX server to automatically login without prompt-ing a password. 1. SSH must be installed in both servers. (primary...
Thursday, September 7, 2017
BI Report Testing Trends
Atul Singh
September 07, 2017
Extending my quite old post ( ETL Testing - Trends and Challenge - link ) by sharing my thoughts on BI Report Testing Issues and Solutions....
Saturday, August 12, 2017
Delete all lines in Notepad++ except lines containing a pattern
Atul Singh
August 12, 2017
Who dont want to keep the only items which needed and we want to have when working with lots of junk data and want to fetch only which requ...
Wednesday, July 26, 2017
View Hidden File in WinSCP
Atul Singh
July 26, 2017
Recently I have stuck with the problem where I have to download one of configuration file from server which is hidden. Usually we use WinSC...
Thursday, July 13, 2017
Utility to Get Last Run Log of DataStage Job
Atul Singh
July 13, 2017
Love the new feature of IBM DataStage to fetch the last run log of any jobs with the help of "dsjob" command. In older version o...
Wednesday, July 12, 2017
How to Run Python Code in NotePad++
Atul Singh
July 12, 2017
Can you run the python code from NotePad++ ?? Question seems to be little odd but we can tweak our notepad++ settings and configure it that...
Friday, July 7, 2017
ICONV mystery - the UV function
Atul Singh
July 07, 2017
Iconv (Internal CONVersion) is a function supported by UniVerse DB (UV db) to convert the DATA, not only DATE, into internal format. Data...
Wednesday, July 5, 2017
Conditionally Aborting Jobs with Transformer Stage
Atul Singh
July 05, 2017
How to develop a job which will stop processing when FROM_DATE and TO_DATE is equal in data? Or I want to abort the job when reject row co...
Monday, June 19, 2017
Crontab for Windows #iLoveScripting
Atul Singh
June 19, 2017
While working on one of my project, I required to take backup of all the work which I have completed coz workplace is shared among many dev...
Wednesday, May 31, 2017
Remove ctrl-M character from all files within Directory #iLoveScripting
Atul Singh
May 31, 2017
Continuing our journey on #iLoveScripting ,.............. This script will do the same task as "clnM.sh" but this will accept D...
Tuesday, May 30, 2017
Remove ctrl-M character from file #iLoveScripting
Atul Singh
May 30, 2017
This is my first post under #iLoveScripting which will have lots of shell script which are helping me in my day to day task and sharing he...
Sunday, May 21, 2017
dos2unix - A script to convert DOS to LINUX formatting #iLoveScripting
Atul Singh
May 21, 2017
dos2unix - a simple filter to convert text files in DOS format to UNIX/LINUX end of line conventions by removing the carriage return char...
Friday, May 12, 2017
#3 - Measuring Data Similarity or Dissimilarity
Atul Singh
May 12, 2017
Continue from - 'Measuring Data Similarity or Dissimilarity #1' 'Measuring Data Similarity or Dissimilarity #2 ' , ...
Tuesday, May 9, 2017
Measuring Data Similarity or Dissimilarity #2
Atul Singh
May 09, 2017
Continuing from our last discussion 'Measuring Data Similarity or Dissimilarity #1' , In this post we are going to see how to cal...
Monday, May 8, 2017
Measuring Data Similarity or Dissimilarity #1
Atul Singh
May 08, 2017
Yet another question is in data mining to measure whether two datasets are similar or not. There are so many ways to calculate these values...
Tuesday, April 25, 2017
Graphical Display of Basic Stats of Data
Atul Singh
April 25, 2017
After a long time, got a chance to share somethings with you guys, so feeling awesome :-), Today we are gonna see the Graphical Display of...
Wednesday, April 5, 2017
NULL Handling in Sequential File Stage
Atul Singh
April 05, 2017
DataStage has a mechanism for denoting NULL field values. It is slightly different in server and parallel jobs. In the sequential file sta...
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. ...
