InfoSphere Optim data lifecycle management

02 May 2013 — Show descriptions | Hide descriptions

• Modeling created global temporary tables for DB2 with InfoSphere Data Architect 8.5, Part 1: Getting Started

  Leverage InfoSphere Data Architect to create a physical data model with CGTT (created global temporary tables) and then generate a DDL with CGTT-specific syntax that you can run on a database server.

• IBM InfoSphere Optim Test Data Management Solution, Part 3: Masking a person's first name using a gender-specific lookup table

  In this third part in the series about masking sensitive data, learn how to mask a person's first name in a table using a gender-specific lookup table.

• IBM InfoSphere DataStage job validation steps using IBM Optim Test Data Management Solution

  Follow a step-by-step example on how to use DataStage to validate ETL job results when moving jobs from development to production environments.

• Use the InfoSphere Optim 9.1 Test Data Management and Data Masking solution for Netezza Data Warehouse

  Move a subset of data from a Netezza production database to a test database. Using this article, learn how to extract a subset of data, mask sensitive data, audit the masked data, and create a Netezza test database.

• Mask archived and extracted data directly into CSV, XML, and ECM formats using InfoSphere Optim Data Masking Solution

  Increase the interoperability of your data and support data privacy and security requirements using newly supported file format types in InfoSphere Optim Data Masking Solution.

• Compare IBM's data masking solutions: InfoSphere Optim and DataStage

  Learn the similarities and differences between two IBM solutions for masking and depersonalizing data while maintaining its realism, to help you choose the product that meets your needs.

• Use IBM InfoSphere Optim Query Workload Tuner 3.1.1 to tune statements in DB2 Linux, UNIX, and Windows, and DB2 for z/OS that reference session tables

  Using example scripts, learn how to set up a database environment that lets you tune statements from an SQL script editor or from the Query Tuner Workflow Assistant.

• Optim Teradata load techniques and performance tips

  Learn the fundamental load techniques for implementing InfoSphere Optim for Teradata to get the best performance optimization when managing bulk data.

• IBM InfoSphere Optim Query Capture and Replay 1.1 for Linux, UNIX, and Windows, Part 1: Introduction to OQCR

  Create a production-like data application test environment where you can test and tune changes before deploying them to ensure that you do not disrupt your production.