Framework for Datastage

FRAMEWORK FOR DATASTAGE

WHAT SETS US APART?

Overview Framework

  • Loading Staging
  • Typed and non-typed data transfer in staging area
  • harmonization
  • Syntactic harmonization using mapping table and reusable components (shared container)
  • Surrogate key
  • Generate: Allocation of new Surrogate Keys
  • Read: Assignment of an existing Surrogate key to a source system key
  • Delta Determination and Technical Historization
  • Change detection of delivered data against the target table; determination of the basic operation Insert, Update, Delete with subsequent technical historization

Overview Framework

  • Technical logging
  • Logging of harmonization errors, reject records in provided table and using two shared containers
  • Configuration of e-mail notification
  • Technical Metadata
  • Metatables for managing deliveries and production runs
  • Technical logging of the runs for documentation of important parameters
  • Supplying the records inserted or changed in the target table with relevant technical metadata
  • ETL Standards
  • Recommendations for naming conventions and other standard settings

WHAT'S IN IT FOR ME AS A CUSTOMER?
Request trial license
Order the Framework for Datastage for a trial.
Technical advice
Phone +49 (0) 511 5151 3700,