Data Services Designer Workshop
Workshop Description
This two - three day instructor-led course explains how to perform the fundamental data integration tasks in Data Services. Data Services also provides data quality functionality, which will not be discussed in this course.
Having used Data Services in the real world with actual data ITP is able to offer a specialist course which focuses on the issues you are likely to face and the solutions used to solve these problems. For each topic in the course there are exercises which allow the pupil to practice the topic and become hands on.
As well as providing a foundation to learning the core data integration areas of Data Services this course will go a stage further by adding tips and tricks where applicable, thus maximising each topics content.
Workshop Topics
Lesson #1 – Understanding Data Services
- Understanding ETL Tools
- Understanding the data services architecture
- Creating a repository
Lesson #2 – Creating Source and Target Meta Data
- Creating DB Data Stores
- Creating File Stores
Lesson #3 – Creating Jobs
- Understanding the object hierarchy
- Creating a batch job
- Creating workflows
- Creating Dataflows
Lesson #4 – Using platform transforms
- Understanding transforms
- Using platform transforms
Lesson #5 – Using functions, scripts and variables
- Using functions in transforms i.e. Lookup and decode
- Using variable within scripts
Lesson #6 – Using Change Data Capture
- Use source based change data capture
- Use target based change data capture
Lesson #7 – Using Data Integrator Transforms
- Use data integrator transforms
Lesson #8 – Error Handling
- Understand how to debug
- Understand how to handle errors
Lesson #9 – Using a Central Repository
- Understand how to create central repository
- Use a Central Repository for version control
Lesson #10 – Using the Management Console
- Connect to the management console
- Schedule jobs in the management console
The business benefit of this course is focused over four key areas:
- Agility – Leverage features that can accelerate time to market, encourage reuse and collaboration, increase developer productivity, and create unified skill sets.
- Trusted information – Improve the reliability of your data with functions for data governance – including transparency, change management, security, and controls – global data support, and end-to-end metadata management.
- Operational excellence – Gain a single data repository, platform, and environment so you can reduce costs associated with supporting multiple applications; Leverage multi-platform support for 64bit, Unix, Linux, and Windows.
- Enterprise class – Benefit from highly scalable performance with support for parallelization and grid computing, enterprise connectivity, and support for service-oriented architecture (SOA).
Audience
The target audience for this course is technical people wishing to learn how to move and transform data from one place to another, either as part of a data migration project or a data warehouse development.
Pre requisite Knowledge, Experience and Education
- SQL
- Basic Programming Fundamentals
- Data Warehousing – concepts and basics
Delivery & Duration
This is a 2/3 day, instructor led workshop, which can be delivered either on your site or at our venue in Birmingham.
Additional Education
If learners want to learn the fundamentals of the data quality functionality or increase their skill level and knowledge of the Data Services, the following courses are recommended:
- Data Warehousing and Dimensional Modeling
Request More Information
For more information regarding this workshop, please call today 0845 124 9495 and speak to one of our team or complete our short form below.
