Tag: notes
Understanding LUTCreateOp and LUTProcessOp in IBM DataStage
Every so often on DSXchange, DataStage veterans like Ray Wurlod, Craig Hulett, and ArndW share concise explanations of what the…
Aggregator Methods in DataStage: Hash Mode vs. Sort Mode (Courtesy: Ray Wurlod)
Choosing between Hash mode and Sort mode in the IBM DataStage Parallel Aggregator stage is one of the highest-leverage performance…
What Exactly Are Hash Files in DataStage? (Courtesy: Ken Bland)
Editor’s Note: Archived here for quick reference from Ken Bland’s classic DSXchange newsletter tech tip (DSXchange). Full credit to Ken…
DataStage Parallel Transformer Date Derivations Cheat Sheet
When your pipeline cannot join against a calendar/time dimension table, these battle-tested IBM DataStage Parallel Transformer expressions compute common month-end,…
IBM DataStage orchadmin Command Reference Guide
In IBM InfoSphere DataStage, Parallel Datasets (.ds) store a lightweight descriptor file at the target path while distributing raw partition…
Notes on DataStage Bulk Load Tuning with the Oracle Connector
Quick production checklist when configuring high-volume direct-path bulk loads into Oracle using the IBM InfoSphere DataStage Oracle Connector stage: