Using IBM InfoSphere Optim Solutions for Distributed Platforms

Describe the available IBM InfoSphere Optim Solutions and how they fit into Enterprise Data Management
Describe the IBM InfoSphere Optim architecture components
Describe the function and contents of the Optim Directory
Use the Optim Designer to build Optim services
Use the embedded Optim Manager to run and manage Optim services
Describe and utilize the components of an access definition
Describe the process for generating and masking test data
Generate, perform, and validate an extract process
Utilize column maps and table maps
Perform a convert process to mask data
Perform and interpret a compare process
Create database objects using embedded object definitions
Populate destination tables using insert and load processes
Edit and browse test data
Utilize data privacy functions to privatize data
Design, construct, and execute an archive process
Use control files to check archive error conditions
Design and execute delete processes
Use the create utility with insert, restore, and load processes
Perform a selective and a full restore process
Utilize archive actions
Maintain archive indexes
Utilize archive file collections and open data manager (ODM)
Create and utilize Optim primary keys and relationships
Explain relationship traversal concepts
Execute processes from the command line interface
Retry and restart processes
Execute the export and import Directory processes
Describe functional, object, and file access security
List Optim implementation best practices

This basic course is for application developers, business analysts, database administrators, and technical personnel that are involved in implementing IBM InfoSphere Optim Solutions.

You should have:


a working knowledge of Windows
a basic understanding of relational databases
the ability to construct basic SQL statements