Kursbeskrivning: InfoSphere Optim Test Data Mgmt / Data Masking with Designer on Dist Sys - ILO

NOTE: This is an online course. Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course material.

This course is designed to teach you how to use Optim V8.1, Optim Designer V2.2.3, and Optim Manager V2.2.3. This course provides both a conceptual understanding of data masking and test data management as well as the Optim Solution's capabilities for implementing test data management and de-identifying data for privacy protection and supporting compliance initiatives for critical business applications. This course serves as a foundation for the Optim solution's business value, features, and functionality.

This course focuses on the technical aspects of the Optim Solution and is intended for technical audiences. The focus of the course is hands-on experience building relational intact subsets of non-privatized and/or privatized data and creating Optim Primary Keys and Optim relationships which permit cross database extraction of data. You will learn how to setup the Optim Manager; learn how to use the Optim Designer objects necessary to support test data management objectives; and how to create and execute Optim Services. You will learn the basics of how the technology works through hands-on practice and how to apply the technology to business scenarios.

This is the Instructor-led Online version of Classroom course (DT471SE), Self-paced Virtual course (2T471SE) and Web-based course (1T471SE).

Visa den här kursen i andra länder

Tillbaka till toppen

In this basic course you will learn how to setup the Optim Manager; learn how to use the Optim Designer objects necessary to support test data management objectives; and how to create and execute Optim Services.

Tillbaka till toppen

Before taking this course, you should be able to:

• Use basic OS functions such as utilities, file permissions, hierarchical file system, commands and editor
• Discuss basic relational database concepts and objects such as tables, indexes, views and joins

Tillbaka till toppen

• Discuss how the Optim Solution supports a test data management and a data privacy strategy
• Describe how the Optim Solution fits into the architectural landscape
• Choose the appropriate transformation technique
• Discuss how to define selection criteria
• Describe how the Optim Extract process works
• Create table maps and column maps
• Use Optim to create new tables and load those tables with data
• Describe how the Optim convert process works
• Describe how to insert masked data to a target database
• Discuss how to use Optim Compare to compare Extracts of single and multiple tables of data with other Extracts or existing tables
• Describe how to compare multiple sets of data
• Describe to define Optim Relationships and Optim Keys
• Use the Optim utilities to backup and reload the Optim Directory
• Use the Optim utilities to schedule Optim jobs
• Use the Command Line Interface to run Optim processes
• Explain how to use Column Map procedures and exit routines to modify columns
• Discuss the security options available with Optim
• List best practices for Optim implementation
• Transform and mask confidential data including, but not limited to, social security numbers, national IDs, credit