Export DataStage job log from Director Client
Atul Singh
April 12, 2016
These steps are not for exporting log for more than 3-5 jobs as these are manual steps and need to repeat for each job (Yes, each job indi...
Tuesday, April 12, 2016
Sunday, April 10, 2016
5 Tips For Better DataStage Design #12
Atul Singh
April 10, 2016
1. Minimum number of sort stages should be use in a datastage job. “Don’t sort if previously sorted” in sort Stage, this option should be ...
Monday, April 4, 2016
DataStage Scenario #16 - Cross duplicate Removal
Atul Singh
April 04, 2016
Need to remove duplicate where source or destination can be switched. Input: source destination distance cit...
Friday, April 1, 2016
jupyter notebook tip #1
Atul Singh
April 01, 2016
How we can start jupyter notebook from a specific directory? Below, I am sharing a very tiny batch (and linux shell) script which will k...
Wednesday, March 30, 2016
echo the 'echo'
Atul Singh
March 30, 2016
"echo" command is the very basic command of Linux/Unix. Most of us known this command to print whatever is being passed to it ...
Monday, March 28, 2016
10 Scenario based Interview Questions #1 - DataStage
Atul Singh
March 28, 2016
1. Design a job which convert single source row to three target row. 2. Design a job which can identify the row if they are duplicate in i...
Saturday, March 26, 2016
Data Warehouse Glossary #3
Atul Singh
March 26, 2016
Drill Through: Data analysis that goes from an OLAP cube into the relational database. Data Warehousing: The process of designing, buil...
Wednesday, March 23, 2016
5 Tips For Better DataStage Design #11
Unknown
March 23, 2016
When writing intermediate results that will only be shared between parallel jobs, always write to persistent data sets (using Data Set ...
Tuesday, March 22, 2016
Transformer Stage alternative - A Quick DataStage Recipe
Atul Singh
March 22, 2016
What to use instead of "Transformer" Stage Copy Stage Use "Copy" stage instead of "Transformer" Stage fo...
Monday, March 21, 2016
Data Warehouse Glossary #2
Atul Singh
March 21, 2016
Dimension: A variable, perspective or general category of information that is used to organize and analyze information in a multi-dimensio...
