BusinessObjects™ 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.
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 .
