DM377eR2 - BusinessObjects Composer: ETL Design

Goals

• This three-to-four hour eLearning course is designed to provide an overview of how to use Composer to plan data warehousing projects.
• You should take this course to learn how to create and manage projects, users, documents, and table mappings to support the process of creating Extract, Transform, and Load (ETL) designs.
• The business benefit of this course is that the business users who own the data involved in creating a data warehouse will be able to effectively collaborate on the design of the ETL project.

Audience

• The target audience for this course is business users involved in data warehouse planning.

Prerequisites

• * Prerequisite Education
• Not applicable for this offering. * Prerequisite Knowledge/Experience (While not required for this course, experience with these products or technologies will be helpful:)
• Data warehousing concepts

Content

• Getting Started with Composer
• • Define the purpose of Composer
  • Identify the key features of Composer
  • Navigate the Composer user interface
• Setting Up Composer
• • Create and modify task lists to use as templates for ETL projects
  • Upload documents
  • Describe Composer security and the user roles available
  • Create user accounts
  • Create connections to data systems
  • Profile and analyze source data
• Using Composer
• • Create projects in Composer
  • Assign users to projects and tasks
  • Upload project documentation
  • Create mappings between source and target datastores
  • Explore and report on projects
  • Export projects to use as starter jobs in other ETL tools, such as Data Integrator

Notes

• Course length: 3-4 hours
• 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