Data Warehouse Glossary #1
Atul Singh
March 17, 2016
Ad Hoc Query: A database search that is designed to extract specific information from a database. It is ad hoc if it is designed at the...
Thursday, March 17, 2016
Tuesday, March 15, 2016
yet another Shell script to access DataStage job logs
Atul Singh
March 15, 2016
Introduction We have various data warehouses hosted on AIX/Linux/Unix operating systems. DataStage Director is one of the ETL monitori...
Monday, March 14, 2016
Machine Learning - Learning Steps
Atul Singh
March 14, 2016
Step 1 INTRODUCTION TO MACHINE LEARNING Overview of Machine Learning Supervised vs. Unsupervised Learning Classification vs. Regressio...
Machine Learning Links you must Visit
Atul Singh
March 14, 2016
1. Scikit-Learn Tutorial Series - http://buff.ly/1XnDWv6 2. 7 Free Machine Learning Courses - http://buff.ly/1XoBapa 3. k-nearest ne...
DataScience Links you must Visit
Atul Singh
March 14, 2016
1. Python (and R) for Data Science - sample code, libraries, projects, tutorials - http://buff.ly/22bwhXi 2. 19 Worst Mistakes at Data S...
Saturday, March 12, 2016
Capture Unmatched records from Join Stage - A Quick DataStage Recipe
Atul Singh
March 12, 2016
How to capture unmatched records from "Join" Stage. This stage does not provide reject handling for unmatched records (such as i...
Friday, March 11, 2016
Python Points #12 - execute OS commads
Atul Singh
March 11, 2016
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.goog...
Wednesday, March 9, 2016
Python Points #11 - Set
Atul Singh
March 09, 2016
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.google....
Monday, March 7, 2016
Python - Get line no with print statement
Atul Singh
March 07, 2016
Sometime when we are working on some code and there are lot of print statement, It's difficult to check for which print statement produ...
Data Warehouse Approaches #2
Atul Singh
March 07, 2016
Top-down approach(Inmon) The top-down approach views the data warehouse from the top of the entire analytic environment. The data ware...
Sunday, March 6, 2016
Python SyntaxError - Non-ASCII character '\xe2' in file
Atul Singh
March 06, 2016
If you get below error while running your python code - SyntaxError: Non-ASCII character '\xe2' in file .\set_learn.py...
Thursday, March 3, 2016
Data Warehouse Approaches #1
Atul Singh
March 03, 2016
It has been said there are as many ways to build data warehouses as there are companies to build them. Each data warehouse is unique becau...
Wednesday, March 2, 2016
5 Tips For Better DataStage Design #10
Atul Singh
March 02, 2016
1. Establish baselines (especially with I/O), use copy with no output 2. Avoid the use of only one flow for tuning/performance testing. P...
Tuesday, March 1, 2016
ETL Development Standards
Atul Singh
March 01, 2016
These development standards provide consistency in the artifacts the ETL developers create. This consistency improves testing, operationa...
Monday, February 29, 2016
Building Test data from Live Data in DataStage
Atul Singh
February 29, 2016
Datastage is providing below stages to generate test data from live data (real data). We are well aware about these stages but not aware...
