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...
Monday, August 8, 2016
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...
Sunday, May 22, 2016
Tuning SQL Statement #3
Atul Singh
May 22, 2016
Tuning SQL Statement #1....... Tuning SQL Statement #2....... Consider whether a UNION ALL will suffice in place of a UNION. The UNION ...
Wednesday, May 18, 2016
5 Tips For Better DataStage Design #13
Atul Singh
May 18, 2016
1. The query used in the database should be in such a way that required number of rows are fetched. Do not extract the columns which are n...
Tuesday, May 17, 2016
Windows & Linux - Command Comparison
Atul Singh
May 17, 2016
I am a linux command line geek and when I am working on windows I miss it as there are lot of kung-fu which we can do easily in linux term...
Monday, May 16, 2016
Lookup Stage behaviour
Atul Singh
May 16, 2016
Today, I am gonna ask you a question, What value I will get from lookup when my datatype is integer (Not Null) and there is no match b/w s...
