SAP BusinessObjects Data Integrator XI R1/R2:: Extracting, Transforming and Loading Data
Now you can study at home by your self and get certified.
These set teach you everything you need to know to become Certified.
The tests are based directly from the information from these books
BOI200 - DM370R2 - SAP BusinessObjects Data Integrator XI R1/R2:: Extracting, Transforming and Loading Data
BusinessObjects™ Data Integrator XI enables the implementation of ETL (Extract, Transform, and Load) projects from disparate data sources to deliver more timely and accurate data that end users in an organization can trust.
In this course, you will learn about batch data transformation jobs, techniques for capturing changes in data, handling errors, multi-user environment tasks, administering server and migration basics.
The course also shows you how to use tools to audit, profile data, and manage metadata to assist in the implementation of an ETL project.
Activities in this course focus on the tools and features discussed in each lesson and enable you to create dimensions and a fact table. You will have a chance to apply different concepts learned from a few combined lessons in two one-hour comprehensive workshops.
At the end of the course, you will be able to put into practice data flow design concepts in a final two-three hour workshop.
As a business benefit, by being able to create efficient ETL 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.
Describe dimensional modeling
Understanding Data Integrator
Describe components, management tools, and the development process
Explain object relationship
Defining Source and Target Metadata
Create a database datastore and import metadata
Create a new file format and handle errors in file formats
Validating, Tracing and Debugging Jobs
Use descriptions and annotations
Validate and trace jobs
Use View Data and the Interactive Debugger
Creating a Batch Job
Create a project, job, work flow, and data flow
Use the Query transform in a data flow
Use template tables
Using Built-in Transforms and Nested Data
Use the case, merge, and validation transforms
Import metadata from XML documents
Use the XML_Pipeline in a data flow
Using Built-in Functions
Use date and time functions and the date generation transform to bu a dimension table
Use the lookup functions to look up status in a table
Use match pattern functions to compare input strings to patterns
Use database type functions to return information on data sources
Using Data Integrator Scripting Language and Variables
Explain differences between global and local variables
Create global variables and custom functions
Use strings and variables in Data Integrator scripting language
Capturing Changes in Data
Use Changed Data Capture (CDC) with time-stamped sources
Create an initial and delta load job
User history preserving transforms
Handling Errors and Auditing
Recover a failed job
Create a manual, recoverable work flow
Define audit points, rules and actions on failures
Supporting a Multi-user Environment
Describe terminology and repository types in a multi-user environme
Create and activate the central repository
Work with objects in the central repository
Create multiple configurations in a datastore
Work with projects in the central repository
Create a secure central repository
Implement and modify group permissions
Using the Administrator
Add a repository and user roles
Set the job status interval and log retention period
Execute, schedule, and monitor batch jobs
Understand architecture, load balance index, and job execution in server groups
Set up the Data Profiler and users
Submit a profiling task
Monitor profiling tasks in the Administrator
Import and export metadata
Use Metadata Reports
Shipping is free IMMEDIATE DOWNLOAD AFTER PAYMENT .Receive a direct download link in your email in 1 - 3 minutes.
[Do NOT forget to check the junk or Spam mails of your email box]