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 15, 2017
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> <...
Monday, February 27, 2017
ETL Preformance Tuning : Identification of Performance Bottleneck
Atul Singh
February 27, 2017
The goal of performance tuning is to optimize session performance by eliminating performance bottlenecks. To tune the performance of a sess...
Wednesday, February 22, 2017
Shell script to access DataStage Director ETL joblogs
Atul Singh
February 22, 2017
We have various data warehouses hosted on AIX/Linux/Unix operating systems. DataStage Director is one of the ETL monitoring & schedul...
Monday, February 20, 2017
PDF Split & Merge with Perl
Atul Singh
February 20, 2017
Sharing two utility scripts (Perl), which can be used for extracting only few pages from a PDF file and also for combining different pdf fi...
Wednesday, February 8, 2017
get Queue Depths #iLoveScripting
Atul Singh
February 08, 2017
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.googl...
Monday, February 6, 2017
Implementing Slowly Changing Dimension in ETL
Atul Singh
February 06, 2017
Dimension is a term in data management and data warehousing that refers to logical groupings of data such as geographical location, custome...
Friday, February 3, 2017
Learning Matplotlib #2
Atul Singh
February 03, 2017
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.googl...
Thursday, February 2, 2017
Plotting in Python - Learning Matplotlib #1
Atul Singh
February 02, 2017
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.google....
Wednesday, January 18, 2017
5 Tips For Better DataStage Design #17
Atul Singh
January 18, 2017
** There is an automap button in some stages,it can maps fields with the same names. ** When you ...
Sunday, January 15, 2017
Linux Shell Utilities
Atul Singh
January 15, 2017
This shell script can be called from any other shell script as ". UXUtils.sh" and any of the functions can be called to use. Even...
Friday, January 13, 2017
Learning Numpy #2
Atul Singh
January 13, 2017
Continuing the first post NUMPY #1 ....... Click Here for Next Tutorial ~ Like the below page to get update https://...
Wednesday, January 11, 2017
Learning Numpy #1
Atul Singh
January 11, 2017
Numpy is a python library used for numerical calculations and this is better performant than pure python. In this notebook, I have shared s...
Tuesday, January 10, 2017
My Learning Path for Machine Learning
Atul Singh
January 10, 2017
I am a Python Lover guy so my way includes lots of Python points. If you dont know the basics of this wonderful language, start it from HER...
Friday, January 6, 2017
10 minutes with pandas library
Atul Singh
January 06, 2017
View the same Tutorial on NBViewer - LINK Click Here for Next Tutorial ~ Like the below page to get update https://ww...
Wednesday, January 4, 2017
Learning Pandas #5 - read & write data from file
Atul Singh
January 04, 2017
View the same Tutorial on NBViewer - LINK Click Here for Next Tutorial ~ Like the below page to get update https://ww...
Learning Pandas #4 - Hierarchical Indexing
Atul Singh
January 04, 2017
View the same Tutorial on NBViewer - LINK Click Here for Next Tutorial ~ Like the below page to get update https://www....
Sunday, January 1, 2017
Learning Pandas #3 - Working on Summary & MissingData
Atul Singh
January 01, 2017
View the same Tutorial on NBViewer - LINK Click Here for Next Tutorial ~ Like the below page to get update https://www...
Saturday, December 31, 2016
Learning Pandas - DataFrame #2
Atul Singh
December 31, 2016
View the same Tutorial on NBViewer - LINK Click Here for Next Tutorial ~ Like the below page to get update https://...
Friday, December 30, 2016
Learning Pandas - Series #1
Atul Singh
December 30, 2016
View the same Tutorial on NBViewer - LINK Click Here for Next Tutorial ~ Like the below page to get update https://www.fa...
Wednesday, December 28, 2016
Learning Graphlab - SFrame #2
Atul Singh
December 28, 2016
In last post Learning Graphlab - SFrame #1 , we have learn basics of SFrame, like how to create, add or delete the columns in SFrame. In thi...
Thursday, December 22, 2016
DataStage Scenario #17 - Get Transitive relation between columns
Atul Singh
December 22, 2016
Goal : To get the data from two columns which have transitive relationship between them A -> B B -> C then A -> C ...
Tuesday, December 20, 2016
R Points #2 - DataFrame & List Basics
Atul Singh
December 20, 2016
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.goog...
Sunday, December 18, 2016
R Points #1 - Matrix & Factor Basics
Atul Singh
December 18, 2016
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.google...
Saturday, December 17, 2016
R Points #0 - Basics n Vector
Atul Singh
December 17, 2016
======================================================= ======================================================= Like the be...
Monday, December 12, 2016
vmware player powering on internal error
Atul Singh
December 12, 2016
Last night, I struggled with "vmware player powering on internal error" for almost an hour when I was trying to run a vmware os ...
Wednesday, December 7, 2016
Notepad++ tip - Format JSON file
Atul Singh
December 07, 2016
Notepad++ is a very powerful tool with lots of plugins and functionality which can reduce a lot of our work. Today, we will see how to deal...
Tuesday, December 6, 2016
Import the jobs from DS windows client #iLoveScripting
Atul Singh
December 06, 2016
As we have discussed a script which can export the datastage jobs from your client system ( http://bit.ly/2frNPKj ) likewise we can write a...
Tuesday, November 29, 2016
Learning Graphlab - SFrame #1
Atul Singh
November 29, 2016
Hoping you guys went through the last post (Lnk -> Getting Started with Graphlab), In this post we will do some handson SFrame datatype ...
Sunday, November 27, 2016
Getting Started with Graphlab - A Python library for Machine Learning
Atul Singh
November 27, 2016
Before Starting with Graphlab, We have to configure our system with some basic tools such as Python, Jupyter Notebook etc. You can find ...
Sunday, November 20, 2016
Reading DSParam - datastage parameter file
Atul Singh
November 20, 2016
I am sharing a utility which can help you to read DSParam file which holds all the environmental datastage parameters. Utility to view c...
