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, June 7, 2016
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...
