DM240R2 - BusinessObjects Data Federator: Designing On-Demand Federated Views

Goals

• This two-day instructor-led course teaches you how to create virtual tables using BusinessObjects™ 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.

Audience

• 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.

Prerequisites

• * Prerequisite Education:
• Not applicable for this offering * Prerequisite Knowledge:
• 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

Content

• 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

Notes

• Additional Education
• • Not applicable for this offering.
• Applicable Certification
• • This course is not applicable to any Business Objects Certified Professional programs.

Popular tags

No tags submitted for this course yet