DataStage Partitioning #3
Atul Singh
November 13, 2016
Best allocation of Partitions in DataStage for storage area Srno No of Ways Volume of Data Best way of Partition ...
Showing posts with label Partitioning. Show all posts
Showing posts with label Partitioning. Show all posts
Sunday, November 13, 2016
Friday, November 11, 2016
DataStage Partitioning #2
Atul Singh
November 11, 2016
Keyless partition Round Robin Entire Same Random Round Robin The first record goes to the first processing node,...
Wednesday, November 9, 2016
DataStage Partitioning #1
Atul Singh
November 09, 2016
Partitioning mechanism divides a portion of data into smaller segments, which is then processed independently by each node in parallel. It ...
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....
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...
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...
Friday, January 8, 2016
5 Tips For Better DataStage Design #7
Atul Singh
January 08, 2016
#1. In case the partition type for the next immediate stage is to be changed then the ‘Propagate partition’ should be set to ‘Clear’ in th...
Wednesday, September 9, 2015
DataStage Terminology
Unknown
September 09, 2015
DataStage Term Description DataStage Administrator Client program that is used to manage the ...
