Using InfoSphere Data Architect Training  

• InfoSphere Data Architect Introduction
• Describe the basic architectural elements of the Eclipse Graphical User Interface (GUI)
• Explain the InfoSphere Data Architect Views and their contents
• Relate the functions of the Search tool
• Logical Data Modeling
• Relate the concepts of a logical data model and notation techniques for its diagram
• Explain how a logical data model is represented in the various InfoSphere Data Architect Views in the Eclipse Graphical User Interface (GUI)
• Describe the InfoSphere Data Architect functions to create a project, a logical data model in the project, and the logical data model elements
• State the purpose and usage of a Glossary Model and a Domain Model
• Web Publishing and BIRT Reporting
• Use Web Publishing interface as a means of publishing your logical or physical model in HTML or PDF format
• Explain the level of details of the report, so as to be able to use the report as means of documentation as well as means of collaborating with your project team.

Physical Data Modeling and Transformations

• Discuss the various ways to create a physical data model
• Explain how to create a physical data model from an existing logical data model
• Describe the capabilities of InfoSphere Data Architect to perform DB2 for zSeries storage modeling for the physical data model
• Relate the usage of the InfoSphere Data Architect model analysis facility
• List the steps to generate DDL to deploy the completed physical data model
• State the InfoSphere Data Architect process to reverse engineer an existing physical database to a physical data model
• Describe the functions available with the InfoSphere Data Architect Data Source Explorer View

Database Lifecycle Management

• List the major activities for lifecycle management of the database and associated models
• Describe how to setup and use InfoSphere Data Architect Team Support with Eclipse CVS or with ClearCase Remote Client
• Explain how to use the InfoSphere Data Architect Compare and Synch features to manage concurrency and accuracy of data models
• Relate the reasons for an impact analysis and the steps to perform an impact analysis
• State the basic data model transformation functions

Validation and Dependency Analysis

• Describe how to invoke the analysis of a data model
• Explain and evaluate the results of a model analysis
• Describe how to invoke the impact analysis function
• Explain and evaluate the results of an impact analysis

Mapping Models and Data Integration

• Explain what mapping models are used for
• Create a new mapping model
• Configure mappings
• Configure mapping groups
• Generate scripts based on mapping models
• Discuss how InfoSphere Data Architect can integrate with InfoSphere Metadata Server