Goals

• Participants will gain the knowledge to participate in implemeting, adminstering, and managing data integration projects
• The knowledge you will acquire will form the basis for more advanced training in Data Quality Services

Audience

• Project team members with basic knowledge of Data Warehousing and data integration concepts
• Data Warehousing consultants and project managers who work with data integration

Prerequisites

Essential

• Basic knowledge of data warehousing and ETL (Extraction, Transfer and Loading) concepts

Recommended

• Basic knowledge of SQL language
• Basic knowledge of elementary procedural programming

Content

• Describing Data Services
• Examing data acquisition and process chains
• Creating batch jobs for data integration
• Troubleshooting batch jobs
• Using functions, scripts and variables
• Using Platform Transforms
• Setting up error handling
• Capturing change in data
• Using the data integrator platform transforms