ETL-Tools.Info

Business Intelligence - Data warehousing - ETL
Google

  • del.icio.us
  • Technorati
  • Digg
  • Sphinn

Datastage tutorial & guide table of contents:

  • Lesson 1. Datastage-modules
  • Lesson 2. Designing jobs - datastage palette
  • Lesson 3. Extracting and loading data - ODBC and ORACLE stages
  • Lesson 4. Extracting and loading data - sequential files
  • Lesson 5. Transforming and filtering data
  • Lesson 6. Performing lookups in Datastage
  • Lesson 7. Implementing ETL process in Datastage
  • Lesson 8. SCD implementation in Datastage
  • Lesson 9. Datastage jobs real-life solutions
  • Lesson 10. Header - Items processing example


    • Datastage server job designs

    Examples of datastage server job designs which are solutions for real problems in the data warehouse environment.

    Design of a DataStage server job with Oracle plsql procedure call
    Design of a DataStage server job with Oracle plsql procedure call

    Example of a DataStage server aggregation job with use of containters
    Example of a DataStage server aggregation job with use of containters

    Datastage sequences examples


    Design of a Datastage job sequence with email notification
    Design of a Datastage job sequence with email notification


    Design of a complex Datastage server job sequence with parallel job execution
    Design of a complex Datastage server job sequence with parallel job execution
    (c) 2006-2008 ETL-tools.Info 
    All Rights Reserved