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...
Tuesday, May 31, 2016
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...
Tuesday, May 10, 2016
ETL Data Validation
Atul Singh
May 10, 2016
Organizations typically have “dirty data” that must be cleansed or scrubbed before being loaded into the data warehouse. In an ideal ...
Sunday, May 8, 2016
The DW Testing Life Cycle
Atul Singh
May 08, 2016
As with any other piece of software a DW implementation undergoes the natural cycle of Unit testing, System testing, Regression testing, I...
Friday, May 6, 2016
DS Fatal Error: Destination "APT_TRinput0Rec0" is already bound
Atul Singh
May 06, 2016
Fatal Error: Destination "APT_TRinput0Rec0" is already bound - Transformer Stage Error Solutions: * Check if the output sta...
Tuesday, May 3, 2016
Otherwise Constraint - A Quick DataStage Recipe
Atul Singh
May 03, 2016
Recipe: How to use "Otherwise" constraint in Transformer Stage How To: To use "Otherwise" constraint in Trans...
