SAP BusinessObjects Data Integrator XI 3.0/3.1: Core Concepts

Product type
Logo SAP Training
Provider rating: starstarstarstar_halfstar_border 6.5 SAP Training has an average rating of 6.5 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

Description

Goals

  • BusinessObjects™ Data Integrator XI 3.0/3.1 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 fr…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Cisco Data Center, Cisco, CompTIA A+ / Network+ / Security+, IT Security, and Professional Networking.

Goals

  • BusinessObjects™ Data Integrator XI 3.0/3.1 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.

Audience

  • This course is designed for individuals responsible for implementing, administering, and managing data integration projects.

Prerequisites

Essential
  • * Prerequisite Education
  • Not applicable for this offering. * Prerequisite Knowledge/Experience (To be successful, learners who attend this course should have experience with the following:)
  • Knowledge of data warehousing and ETL concepts
  • Experience with MySQL and SQL language
  • Experience using functions, elementary procedural programming, and flow-of-control statements such as If-Then-Else and While Loop statements
  • Data Warehouse Fundamentals: TCO Starts with the End User and Fact Tables and Dimension Tables
  • Data Warehouse Architecture and Modeling: There Are No Guarantees
  • Advance Dimension Table Topics: Surrogate Keys,It's Time for Time, and Slowly Changing Dimensions
  • Industry- and Application-Specific Issues: Think Globally, Act Locally
  • Data Staging and Data Quality: Dealing with Dirty Data It is also recommended you review the following articles, which can be found at: http://www.rkimball.com/html/articles.html .
  • Data Warehouse Fundamentals: TCO Starts with the End User and Fact Tables and Dimension Tables
  • Data Warehouse Architecture and Modeling: There Are No Guarantees
  • Advance Dimension Table Topics: Surrogate Keys,It's Time for Time, and Slowly Changing Dimensions Industry- and Application-Specific Issues: Think Globally, Act Locally
  • Data Staging and Data Quality: Dealing with Dirty Data

Content

  • Describing Data Services
    • Describe the purpose of Data Services
    • Describe Data Services architecture
    • Define Data Services objects
    • Use the Data Services Designer interface
  • 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
  • Creating Batch Jobs
    • Work with objects
    • Create a data flow
    • Use the Query transform
    • Use target tables
    • Execute the job
  • Troubleshooting Batch Jobs
    • Use descriptions and annotations
    • Validate and tracing jobs
    • Use View Data and the Interactive Debugger
    • Use auditing in data flows
  • 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
  • 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
  • Setting up Error Handling
    • Set up recoverable work flows
  • Capturing Changes in Data
    • Update data over time
    • Use source-based CDC
    • Use target-based CDC
  • 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

Notes

  • Additional Education
    • Not applicable for this offering.
  • Applicable Certification
    • Not applicable for this offering.
  • Additional Information
    • Contact your SAP Education Representative.

Popular tags

No tags submitted for this course yet

There are no reviews yet.

    Share your review

    Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

    There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.