BusinessObjects Data Federator XIR2:Designing on Demand Federated Views UK Classes & Lessons (Business Objects)

About this class

This two-day instructor-led course teaches you how to create virtual tables using BusinessObjectsT Data Federator XI R2, manage metadata definitions, create views to generate the SQL queries and define the mapping between the source tables and the virtual table. This course also describes how to draft and deploy Data Federator projects and use tools to administrate the Data Federator Query Server.

Who will the lesson benefit?

The target audience for this course is data managers who are new to Data Federator and who are responsible for providing a federated view of distributed and heterogeneous data.

What prerequisites are required

While not required for this course, experience with these products or technologies will be helpful:

Database management and data warehousing skills
ETL technology such as BusinessObjects Data Integrator XI

Contents of this class

Introducing Data Federator

Data Federator concepts
Data Federator architecture
How to use the Data Federator Designer
How data federation differs from extraction, transformation, load (ELT) technology
The benefits of Data Federator

Determining the Data to Include in the Target Table

What data to include in the target table
How to create a new target table
How to create a target by copying a data source schema

Mapping the Source Data to the Target Table

The basic mapping rule concepts
How to create mapping rules with multiple data sources
How to create and administer a lookup table in a mapping rule
Multiple mapping rule management techniques

Refining the Mapping Rule Definitions

How cases and aggregates are used to refine mapping rules
How to create case statement formulas
The benefits and caveats of combining case statements
Aggregate formula concepts
How to manage multiple mapping rules on a single target table

Ensuring the Integrity of Target Data

Data integrity concepts
How to resolve key conflicts
Integrity checking procedures and best practice

Managing Projects

Manage Data Federator projects
Manage project evolution

Administer the Query Server

The Query Server Architecture
Managing Data Federator users and resources