DW BODI Contents

BODI 11.2(DATA INTEGRATOR)

Introduction to Data Integrator

* About Data Integrator
* Data Integrator product documentation

Data Integrator Architecture

* Standard Data Integrator components
* Optional Data Integrator components
* Data Integrator management tools
* Data Integrator operating system platforms
* Data Integrator distributed architecture

Data Integrator Designer

Introduction to Data Integrator Designer

* Logging in to the designer
* Designer overview
* Data Integrator objects
* Working with objects
* General and environment options
* Projects and Jobs
* Data stores
* File formats
* Data flows
* Work flows
* Nested data
* Real-time jobs
* Embedded data flows
* Variables and Parameters
* Executing jobs
* Data Quality
* Design and Debug
* Data Cleansing

Transforms

* About transforms,operation codes
* Address_Enhancement
* Case
* Date_Generation
* Effective_Date
* Hierarchy_Flattening
* History_Preserving
* Key_Generation
* Map_CDC_Operation and Map_Operation
* Match_Merge
* Merge Name_Parsing
* Pivot(columns to rows) and Reverse Pivot(rows to columns)
* Query
* Row_Generation
* SQL
* Table_Comparison
* Validation
* XML_Pipeline

Functions and Procedures

* Overview of functions
* About functions
* Custom functions
* Database and application functions
* Description of built-in functions
* About procedures
* Calling stored procedures
* In general
* From queries
* Without the function wizard

Data Integrator Scripting Language

* About scripting language
* Language syntax
* Syntax for statements in scripts
* Syntax for column and table references in expressions
* Strings
* Quotation marks
* Escape characters
* Trailing blanks
* Variables
* Variable interpolation
* Functions and Stored procedures
* Operators
* NULL values
* NULL values and empty strings
* Debugging and Validation
* Keywords
* Sample scripts
* Export/import

Data Integrator Administrator

* Introduction
* Administrator Management
* Central Repository Management
* Using Server Groups
* Executing batch jobs
* Scheduling jobs
* Trace and monitoring jobs
* Export Execution command
* Using the Administrator
* Using a third-party scheduler
* Data Integrator job launcher

Data Integrator Metadata Reports

* Introduction
* Viewing Metadata Reports

Data Integrator Performance Optimization

* Introduction
* Environment Test Strategy
* Measuring and Tuning Data Integrator Performance
* Using Bulk Loading