BusinessObjects Data Integrator XI 3.0: Core Concepts
Duration 3 Days
AudienceThis course is designed for individuals responsible for implementing, administering, and managing data integration projects.
PrerequisitesNot applicable for this offering.
SynopsisBusinessObjects™ Data Integrator XI 3.0 enables you to integrate disparate data sources to deliver more timely and accurate data that end users in an organization can trust. In this three-day course, you will learn about creating, executing, and troubleshooting batch jobs, using functions, scripts and transforms to change the structure and formatting of data, handling errors, and capturing changes in data.

As a business benefit, by being able to create efficient data integration projects, you can use the transformed data to help improve operational and supply chain efficiencies, enhance customer relationships, create new revenue opportunities, and optimize return on investment from enterprise applications.
Objectives
TopicsLesson #1 - Describing Data Services
  • Describe the purpose of Data Services
  • Describe Data Services architecture
  • Define Data Services objects
  • Use the Data Services Designer interface

    Lesson #2 - Defining Source and Target Metadata
  • Use datastores
  • Use datastore and system configurations
  • Define file formats for flat files
  • Define file formats for Excel files
  • Define file formats for XML files

    Lesson #3 - Creating Batch Jobs
  • Work with objects
  • Create a data flow
  • Use the Query transform
  • Use target tables
  • Execute the job

    Lesson #4 - Troubleshooting Batch Jobs
  • Use descriptions and annotations
  • Validate and tracing jobs
  • Use View Data and the Interactive Debugger
  • Use auditing in data flows

    Lesson #5 - Using Functions, Scripts, and Variables
  • Define built-in functions
  • Use functions in expressions
  • Use the lookup function
  • Use the decode function
  • Use variables and parameters
  • Use Data Services scripting language
  • Script a custom function

    Lesson #6 - Using Platform Transforms
  • Describe platform transforms
  • Use the Map Operation transform
  • Use the Validation transform
  • Use the Merge transform
  • Use the Case transform
  • Use the SQL transform

    Lesson #7 - Setting up Error Handling
  • Set up recoverable work flows

    Lesson #8 - Capturing Changes in Data
  • Update data over time
  • Use source-based CDC
  • Use target-based CDC

    Lesson #9 - Using Data Integrator Transforms
  • Describe the Data Integrator transforms
  • Use the Pivot transform
  • Use the Hierarchy Flattening transform
  • Describe performance optimization
  • Use the Data Transfer transform
  • Use the XML Pipeline transform Americas
    		•