5 Tips For Better DataStage Design #17
Atul Singh
December 01, 2020
1. For data being passed between Jobs, such as parallel jobs in a sequence, Datasets must be used and not sequential files. 2. Utility jobs...
Showing posts with label designer. Show all posts
Showing posts with label designer. Show all posts
Tuesday, December 1, 2020
Wednesday, January 18, 2017
5 Tips For Better DataStage Design #17
Atul Singh
January 18, 2017
** There is an automap button in some stages,it can maps fields with the same names. ** When you ...
Sunday, August 21, 2016
5 Tips For Better DataStage Design #15
Atul Singh
August 21, 2016
1. Stage variable does not accept null value. Hence no null able column should be directly mapped to stage variable without null handling....
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...
Sunday, April 24, 2016
Suppress Warnings - A Quick DataStage Recipe
Atul Singh
April 24, 2016
Recipe: How to suppress job warnings in DS job log HowTo: Add "rule" in Message Handler Method: From DS Director, f...
Monday, April 18, 2016
10 Scenario based Interview Questions #2 - DataStage
Atul Singh
April 18, 2016
11. Design a job which insert the data if not exists and update if exists in target 12. Design a job which includes a header and footer i...
Wednesday, April 13, 2016
ETL Code Review Checklist
Atul Singh
April 13, 2016
Guideline Design jobs for restartability/ if not designed then what is the reason ? Do not follow Sequential File s...
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...
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...
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...
Wednesday, March 2, 2016
5 Tips For Better DataStage Design #10
Atul Singh
March 02, 2016
1. Establish baselines (especially with I/O), use copy with no output 2. Avoid the use of only one flow for tuning/performance testing. P...
Tuesday, February 23, 2016
DataStage Scenario #15 - Get First & Last Date of Last Month
Unknown
February 23, 2016
Design a job which can generate the First and Last date of Last Month and pass this into an SQL which executes inside a parallel job? ...
Monday, February 15, 2016
5 Tips For Better DataStage Design #9
Unknown
February 15, 2016
#1. Always save the metadata (for source, target or lookup definitions) in the repository to ensure re-usability and consistency. #2. M...
Friday, February 5, 2016
DataStage Scenario #14 - Get Day specific file
Atul Singh
February 05, 2016
Hi Guys, Design jobs for one more realtime scenario - Requirement- Job will run once in a day, which read a file from a folder, but...
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...
Wednesday, January 13, 2016
DataStage Scenario #12 - Combine data column wise
Atul Singh
January 13, 2016
Col1 Col2 Col3 1 2 3 4 5 6 7 8 9 Col4 Col5 Col6 a b ...
Wednesday, December 23, 2015
5 Tips For Better DataStage Design #6
Atul Singh
December 23, 2015
#1. If you are using a copy or a filter stage either immediately after or immediately before a transformer stage, you are reducing the eff...
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 ...
