Training

• BusinessObjects Data Federator XI 3.0/3.1™ enables you to create virtual tables, manage metadata definitions, create views to generate the SQL queries, and define mapping between the source tables and the virtual table.
• This course also shows you how to manage draft and deployed Data Federator projects, as well as how to use tools to administer the Data Federator Query Server.

• Understand Data Federator concepts
• Understand Data Federator architecture
• Work with Data Federator Designer
• Understand data federation versus extraction, transformation, and load technology
• Understand the benefits of Data Federator

• Work with target tables
• Work with source tables
• Manage the datasource work flow

• Understand mapping rule concepts
• Create mapping rules with multiple datasources
• Use lookup tables and domain tables in a mapping rule

• Use cases and aggregates to refine the mapping rule
• Use case statement formulas
• Understand aggregate formula concepts
• Apply multiple mapping rules on a single target table

• Manage Data Federator projects
• Merge Data Federator projects
• Manage project evolutions

• Manage Data Federator projects
• Merge Data Federator projects
• Manage project evolutions

• Manage users and roles
• Manage resources
• Control query execution

To be successful, you must have working knowledge of:

• Data warehousing and ETL concepts.