5 Tips For Better DataStage Design #18
Atul Singh
December 04, 2020
1. Use Database Connector Stages wherever possible - Older “Enterprise” stages must not be used - ODBC stages must not be used whe...
Showing posts with label Lookup. Show all posts
Showing posts with label Lookup. Show all posts
Friday, December 4, 2020
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...
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...
Monday, February 1, 2016
5 Tips For Better DataStage Design #8
Atul Singh
February 01, 2016
#1. Templates have to be created to enhance reusability and enforce coding standard. Jobs should be created using templates. #2. The temp...
Tuesday, November 24, 2015
DataStage Scenario #10 - two realtime scenario
Atul Singh
November 24, 2015
Hello guys, Hoping you are enjoying while solving DataStage Scenarios. Today I am going to ask two real time scenario. try to solve these ...
Tuesday, September 29, 2015
DataStage Scenario #6 - Populate 'Not Found'
Atul Singh
September 29, 2015
Scenario: Design a job which read a flat file and populate the output as NOT FOUND which is not available in the other file. Exa...
Saturday, August 22, 2015
VLookup in MS Excel
Atul Singh
August 22, 2015
We all agree on this, we have to use MS Excel in our day to day work whether it is technical or not. A day before I came across a Excel F...
