Sunday, 24 December 2017

Common UNIX scripts for ETL

Shell scripting for ETL
Batch Start
File Transfer
File watcher
File validation
Generic Run Script
Archive , housekeeping
Batch End

Common Scenarios
Text Manipulation ( File changes based on pattern)
Find Files and perform specific actions on them

Datastage Specific
Find Datastage jobs based on text pattern
Compile multiple Datastage jobs