Building Test data from Live Data in DataStage
Atul Singh
February 29, 2016
Datastage is providing below stages to generate test data from live data (real data). We are well aware about these stages but not aware...
Monday, 29 February 2016
Friday, 26 February 2016
Audit Strategy in ETL #2
Atul Singh
February 26, 2016
First - Audit Strategy in ETL #1 As shown in the above diagram, the audit services are dependent on source systems and target syste...
Audit Strategy in ETL #1
Atul Singh
February 26, 2016
The Audit service will provide simple measures on the ETL process: number of records input/output, number of rejected records, number of r...
Tuesday, 23 February 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, 22 February 2016
Python Points #10d - Writing into Files
Unknown
February 22, 2016
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.googl...
Tuesday, 16 February 2016
Python Points #10c - File Methods
Atul Singh
February 16, 2016
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.googl...
Monday, 15 February 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...
Saturday, 6 February 2016
Python Points #10b - Reading Files
Atul Singh
February 06, 2016
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plu...
Friday, 5 February 2016
Python Points #10a - Reading Files
Atul Singh
February 05, 2016
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.go...
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...
Thursday, 4 February 2016
DataStage Scenario #13 - Validate Decimals
Unknown
February 04, 2016
Input: Data 1 2 3 4. 345 423 4w 4232.23 42342.43243 56765.74 545 4 4o 646. 4343 3232. 4232 ...
Wednesday, 3 February 2016
Python Points #9 - Tuples
Atul Singh
February 03, 2016
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.goog...
Monday, 1 February 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...
