oralce大学ODI培训资料07.pptVIP

Organizing ODI Models and Creating ODI Datastores ;Objectives;Organizing Models;What Is a Model Folder?;Creating a Model Folder;What Is a Submodel?;Creating a Submodel;Organizing Datastores into Submodels;Setting Up Automatic Distribution;Creating Datastores;Creating Datastores;Creating a Datastore in a Model;Adding Columns to a Datastore;Constraints in ODI;What Is a Constraint in ODI?;Constraints in ODI;Creating a Mandatory Column;Creating Keys and References;Creating a Key;Checking a Key;Creating a Reference;Creating a Simple Reference;Creating a Complex Reference;1. Click the Control tab. 2. Select when the constraint should be checked (Flow/Static). 4. Click the Check button to immediately check the reference.;Creating Conditions;Creating a Condition;Checking a Condition;Overview;When and Why?;An Overview of the Process;Exploring Your Data;Displaying the Contents of a Datastore;Viewing the Distribution of Values;Analyzing the Contents of a Datastore;Constructing Business Rules;Defining Business Rules in ODI;From Business Rules to Constraints;Deducing Constraints from Data Analysis;Testing a Constraint;Auditing a Model or Datastore;How to Review Erroneous Records;Quiz;Quiz;Summary;Checklist of Lab Practice Activities;Practice 7-1 Overview