Index

A B C D E F G H I L M N O P R S T U V W X

A

ABAP

scripts, generating, 4.9.7.2

accessing

transformation libraries, 10.3.2

active configuration, 11.3.1

activities

in process flows, 8.4.1

activity templates, 8.5

adding

mapping operators, 7.4

addresses, cleansing, 5.3.13

analytic workspace, 6.3.2.3.1

applying

data rules, 5.8.2

attribute analysis, 5.2.2.1

attribute properties, setting, 7.9

attributes

connecting, 7.6.1

dimension attributes, 6.4.3.1

level attributes, 6.4.3.3

setting properties, 7.9

auto binding

rules, 6.4.4.2

B

BI lifecycle, 22

BINARY_DOUBLE data type, 6.1.1

BINARY_FLOAT data type, 6.1.1

binding

about, 6.3.2.1.1

auto binding, 6.3.2.1.1

auto binding, rules, 6.4.4.2

manual binding, 6.3.2.1.1

BLOB data type, 6.1.1

business definitions

about, 4.10.2

deploying, 11.2.2

deriving, 6.13

Business Domain, 4.6.1.1, 4.7.1.1, 4.8.1.2, 4.9.5.1

business identifier, 6.4.3.2.2

business intelligence objects

about, 4.10.1

deploying, 11.2.2

deriving, 6.13

business names

business name mode, 3.2.8.1

maximum length, 3.2.8.1

requirements, 3.2.8.1

syntax for business object names, 3.2.8.1

C

CA ERwin

importing designs from, 16

CASS reporting, 5.3.16

changes

propagating through multiple BI environments, 22

rolling out to the target schema, 21

CHAR data type, 6.1.1

cleansing

addresses, 5.3.13

names, 5.3.13

CLOB data type, 6.1.1

coding conventions, Preface

collections

Create Collection Wizard, 3.3.1

creating, 3.3.1

deleting shortcuts in, 3.3

editing, 3.3.2

renaming, 3.3.2.1

commit strategies

committing multiple mappings, 9.1.5

committing to multiple targets, 9.1.3.1

configurations

about, 11.3.1

activating, 11.3.1.2

active configuration, 11.3.1

creating, 11.3.1.1

named configuration, 11.3.1

setting properties, 11.3.2.2

configuring

data objects, 6.10

data profiles, 5.6.3.1

master-detail mappings, 9.2.1.2

master-detail mappings, direct path load, 9.2.2

PL/SQL mappings, 9.1

runtime parameters, SAP files, 4.9.7.2

SAP file physical properties, 4.9.7.2

SAP, loading type parameter, 4.9.7.2

connecting

attributes, 7.6.1

groups, 7.6.2

operators, 7.6

connectivity

ODBC, 4.2

OLE DB drivers for heterogeneous data sources, 4.2

connectivity agent, 4.2

connectors

about, 11.1.6

creating, database connector, 11.1.6

creating, directory connector, 11.1.6

containers

SAP application, 4.9.4

control centers

about, 11.1.4

activating, 11.1.4.2

creating, 11.1.4.1

conventional path loading

for master-detail relationships, 9.2.1.2

master-detail flat files, 9.2.1.2

conventions

coding, Preface

example, Preface

correlated commit, design considerations, 9.1.3.1

creating

collections, 3.3.1

control centers, 11.1.4.1

cubes, 6.9.4

data auditors, 5.9.1

data profiles, 5.6.2

data rules, 5.8.1

dimensional objects, 6.3.1

dimensions, 6.9.2

display sets, 7.5.5.1

locations, 11.1.5.1

mappings, 7

PL/SQL types, 10.4.2, 10.4.2.3

pluggable mappings, 7.7.1

process flows, 8.2.3

relational data objects, 6.9.1

time dimensions, 6.9.3

cubes, 6.7

creating, 6.9.4

default aggregation method, 6.7.1.2

dimensionality, 6.7.1.2

example, 6.7.1.3

measures, 6.7.1.1

MOLAP implementation, 6.7.2.3

relational implementation, 6.7.2.1

ROLAP implementation, 6.7.2.1

solve dependency order, 6.7.3

custom transformations

about, 10.2.1.2

defining, 10.4

editing, 10.5

D

data

cleansing, 5.3.13

test, 7.12.3

viewing, 6.2.1

data auditors

creating, 5.9.1

using, 5.9.2

data flow operators, 7.3.5.2

data model designs

importing from third-party tools, 16

Data Object Editor

components, 6.2

creating data objects, 6.2.2

starting, 6.2

using, 6.2.2

data objects

about, 6.1

data type for columns, 6.1.1

dimensional objects, creating, 6.3.1

dimensional objects, implementing, 6.3.2

editing, 6.2.2

monitoring data quality, 5.9

naming conventions, 6.1.2

validating, 6.11

viewing, 6.2.1

data profiles

configuring, 5.6.3.1

creating, 5.6.2

data profiling

about, 5.2

generating corrections, 5.6.6

performance tuning, 5.7

performing, 5.6

steps, 5.6

types, 5.2.2

types, attribute analysis, 5.2.2.1

types, functional dependency, 5.2.2.2

types, referential analysis, 5.2.2.3

viewing corrections, 5.6.6

viewing results, 5.6.4

data quality

ensuring, 5

Match-Merge operator, 5.3.1

data quality operators, 5.3

data rules

about, 5.4

applying, 5.8.2

creating, 5.8.1

deriving, 5.6.5

using, 5.8

data sources

defining SAP objects, 4.9.4

E-Business Suite, 4.6

flat files, 4.4.2

Microsoft Excel, 12

Oracle Heterogeneous Services, 4.2

Oracle Transparent Gateways, 4.2

PeopleSoft, 4.7

Siebel, 4.8

SQL Server, 13

data types

list of supported, 6.1.1

Data Viewer, 6.2.1

databases

importing definitions from, 4.4.1

reimporting definitions, 4.5

DATE data type, 6.1.1

debugging

mappings, 7.12

starting point, 7.12.6.3

default naming mode, 3.2.8.1

defining

ETL process for SAP objects, 4.9.7

mappings, 7

mappings containing SAP objects, 4.9.7.1

process flows, 8.2

schedules, 11.5

test data, 7.12.3

updating source definitions, 4.5.2

definitions

importing definitions from a database, 4.4.1

reimporting database definitions, 4.5

deploying

about, 11.1.1

business definitions, 11.2.2

data objects, 11.2.1

deployment actions, 11.1.1.1

deployment errors, 20

deployment results, 11.2.3

deployment status, 11.1.1.2

PL/SQL scripts for transparent tables, 4.9.8.2

process flows, 8.1.1

single design to multiple target systems, 11.3.2.3

deployment actions, 11.1.1.1

deployment and execution

steps, 11.2

deriving

business definitions, 6.13

data rules, 5.6.5

designing

process flows, 8

target schema, 6.8

target schema, dimensional, 6.8.2

target schema, relational, 6.8.1

dimensional objects, 6.3

binding, 6.3.2.1.1

creating, 6.3.1

creating, about, 6.3

deployment options, 6.3.3

implementing, 6.3.2

unbinding, 6.3.2.1.1

dimensions

about, 6.4

binding, 6.4.4.2

business identifier, 6.4.3.2.2

control rows, 6.4.3.8

creating, 6.9.2

dimension attributes, 6.4.3.1

dimension roles, 6.4.3.5

example, 6.4.3.7

hierarchies, 6.4.3.4

implementing, 6.4.4

level attributes, 6.4.3.3

level relationships, 6.4.3.6

levels, 6.4.3.2

MOLAP implementation, 6.4.4.3

parent identifier, 6.4.3.2.3

relational implementation, 6.4.4.1

ROLAP dimension limitations, 6.4.2

ROLAP implementation, 6.4.4.1

rules, 6.4.1

snowflake schema implementation, 6.4.4.1.2

star schema implementation, 6.4.4.1.1

surrogate identifier, 6.4.3.2.1

time dimensions, about, 6.6

value-based hierarchies, 6.4.3.9

direct path loading

for master-detail relationships, 9.2.2

master-detail flat files, 9.2.2

display sets

creating, 7.5.5.1

defined, 7.5.5

displaying

welcome pages for wizards, 3.2.5

DML error logging

about, 7.11

enabling, 7.11.2

in ETL, 7.11.2.1

limitations, 7.11.3

E

E-Business Suite

importing metadata, 4.6

editing

collections, 3.3.2

invalid objects, 6.11.1

PL/SQL types, 10.5.2

process flows, 8.3

transformation properties, 10.5

enabling

DML error logging, 7.11.2

ensuring data quality, 5

error logs

interpreting error logs, 20

error tables

about, 7.11.1

ERwin

importing designs from, 16

ETL

improving runtime performance, 9

example conventions, Preface

Excel files

loading data from, 12

executing

mappings from SQL*Plus, 9.1.5

execution

about, 11.1.2

errors, 20

external tables

loading data from flat files, 15

extracting from master-detail flat files, 9.2.1, 9.2.1.2

F

file transfer

in process flows, 19

filters, with a transform, 10.6

flat files

configuring master-detail mappings, 9.2.2

extracting master and detail records, 9.2.1.2

importing master-detail flat files, 9.2.1.2

loading data from, 15

mapping, 7.2.1

master-detail mappings, post-update scripts for direct path loads, 9.2.2

master-detail, example, 9.2.1

master-detail, extracting from, 9.2.1

master-detail, operations after initial load, 9.2.1.4

variable names, in process flows, 18

FLOAT data type, 6.1.1

foreign keys, ensuring referential integrity, 9.1.6

FTP

using in process flows, 19

functional dependency, 5.2.2.2

functions

as transformations, 10.2.1.2

defining, 10.4

editing, 10.5.1

G

generating

about, 6.12

configuring SAP file physical properties, 4.9.7.2

data objects, 6.12

generating corrections, 5.6.6

generation

errors, 20

global shared library, 10.3.1

group properties, 7.9

groups

connecting, 7.6.2

setting properties, 7.9

H

heterogeneous data sources, 4.2

hiding

welcome pages for wizards, 3.2.5

hierarchies

about, 6.4.3.4

value-based hierarchies, 6.4.3.9

householding, 5.3.1

I

impact analysis

rolling out changes to target schema, 21

implementation

multiple versions of BI implementation, 22

implementing

dimensional objects, 6.3.2

MOLAP cubes, 6.7.2.3

MOLAP dimensions, 6.4.4.3

relational cubes, 6.7.2.1

relational dimensions, 6.4.4.1

ROLAP cubes, 6.7.2.1

ROLAP dimensions, 6.4.4.1

snowflake schema, 6.4.4.1.2

star schema, 6.4.4.1.1

importing

definitions, database systems, 4.4.1

designs from third-party tools, 16

flat files, 4.4.2

from E-Business Suite, 4.6

from flat files, 4.4.2

from Microsoft Excel, 12

from PeopleSoft, 4.7

from SAP R/3, 4.9

from Siebel, 4.8

from SQL Server, 13

Import Metadata Wizard, 4.4.1

master-detail flat files, 9.2.1.2

Oracle database metadata, 4.4.1

PL/SQL functions, 10.6

reimporting database definitions, 4.5

improving runtime performance, 9

INI file for SAP Connector, 4.9.4

input signature, 7.7.1.4

installation

errors, 20

INTEGER data type, 6.1.1

INTERVAL DAY TO SECOND data type, 6.1.1

INTERVAL YEAR TO MONTH data type, 6.1.1

L

language, SAP, 4.9.7.2

languages, setting locale preferences, 3.2.1

levels

dimension, 6.4.3.2

conventional path for master-detail targets, 9.2.1.2

data from Excel files, 12

data from flat files, 15

direct path for master-detail targets, 9.2.2

master and detail records, 9.2.1.2

master-detail relationships, 9.2.1.2, 9.2.2

master-detail relationships, direct path, 9.2.2

SAP data into the workspace, 4.9.8

transaction data, 14

loading types

for SAP, 4.9.7.2

locales, setting, 3.2.1

locations

creating, 11.1.5.1

deleting, 11.1.5.3

registering, 11.1.5.2

unregistering, 11.1.5.2

logical name mode See business name mode

logical names See business names, 3.2.8.1

logs

interpreting error logs, 20

message log preferences, 3.2.7

LONG data type, 6.1.1

M

main procedure, 9.1.5

Mapping Editor

about, 7.3.1

components, 7.3.1

toolbars, 7.3.3

windows, 7.3.2

mapping operators

about, 7.1

adding, 7.4

connecting, 7.6

editing, 7.5

Match-Merge operator, 5.3.1

Name and Address operator, 5.3.13

setting, 7.9

synchronizing with workspace objects, 7.10

that bind to repository objects, 7.4.1

types of, 7.3.5

mappings

about, 7.1

configuring, 9.1

configuring master-detail, 9.2.1.2

creating, 7

debugging, 7.12

defining, 7

defining mappings with SAP objects, 4.9.7.1

executing from SQL*Plus, 9.1.5

for flat files, 7.2.1

for PEL, 9.3.2

master-detail mappings, 9.1.6

naming conventions, 7.5.4, 8.5.1

PL/SQL mappings, 9.1

setting properties, 7.8

master-detail flat files

as sources, about, 9.2.1

configuring mappings, 9.2.1.2

configuring mappings, direct path load, 9.2.2

example of a master-detail flat file, 9.2.1

extracting from, 9.2.1.2

extracting from, using conventional path load, 9.2.1.2

extracting from, using direct path load, 9.2.2

importing and sampling, 9.2.1.2

operations after initial load, 9.2.1.4

performance, 9.2.1.2, 9.2.2

post-update scripts for direct path loads, 9.2.2

RECNUM, 9.2.2

sample mapping, conventional path loading, 9.2.1.2

sample mapping, direct path loading, 9.2.2

match rules

address match rules, 5.3.9

conditional match rules, 5.3.5

custom match rules, 5.3.10

firm match rules, 5.3.8

person match rules, 5.3.7

weight match rules, 5.3.6

Match-Merge operator, 5.3.1

example, 5.3.2

match rules, 5.3.4

merge rules, 5.3.11

restrictions, 5.3.2

using, 5.3.12

MDSYS.SDO_DIM_ARRAY data type, 6.1.1

MDSYS.SDO_DIM_ELEMENT data type, 6.1.1

MDSYS.SDO_ELEM_INFO_ARRAY data type, 6.1.1

MDSYS.SDO_GEOMETRY data type, 6.1.1

MDSYS.SDO_ORDINATE_ARRAY data type, 6.1.1

MDSYS.SDO_POINT_TYPE data type, 6.1.1

MDSYS.SDOAGGRTYPE data type, 6.1.1

message log preferences, 3.2.7

metadata

import and export errors, 20

Import Metadata Wizard, 4.4.1

importing from databases, 4.4.1

importing from flat files, 4.4.2

Microsoft Excel

loading data from, 12

modes

business name mode, 3.2.8.1

logical name mode See business name mode

naming mode, default, 3.2.8.1

physical name mode, 3.2.8.1

modules

defining SAP objects, 4.9.4

process flows, 8.1.1, 8.2.1

SAP application, 4.9.4

MOLAP implementation, 6.3

monitoring

data objects, using auditors, 5.9.2

data quality, 5.9

multiple configurations

scenario, 11.3.2.1

multiple-record-type flat files

master-detail structure, 9.2.1

master-detail structure, example of, 9.2.1

N

Name and Address

country postal certifications, Australia, 5.3.16.3

country postal certifications, Canada, 5.3.16.2

country postal certifications, United States, 5.3.16.1

operator, 5.3.13

purchasing license, 5.3.13

Name and Address operator, 5.3.13

best practices, 5.3.15

CASS reporting, 5.3.16

enabling, 5.3.13

Name and Address server

errors, 20

names

business name mode, 3.2.8.1

business object names, syntax for, 3.2.8.1

cleansing, 5.3.13

default naming mode, 3.2.8.1

flat files with variable names in process flows, 18

logical name mode See business name mode

physical name mode, 3.2.8.1

physical object names, syntax for, 3.2.8.1

naming

modes, default naming mode, 3.2.8.1

objects, business name mode, 3.2.8.1

objects, logical name mode See business name mode

objects, physical name mode, 3.2.8.1

setting naming preferences, 3.2.8

transformation names, 3.2.8.1

naming conventions, for data objects, 6.1.2

NCHAR data type, 6.1.1

NCLOB data type, 6.1.1

non-Oracle database systems

as data sources, 4.2

NUMBER data type, 6.1.1

NVARCHAR2 data type, 6.1.1

O

objects

defining mappings with SAP objects, 4.9.7.1

invalid objects, editing, 6.11.1

syntax for business names, 3.2.8.1

syntax for logical names, 3.2.8.1

syntax for physical names, 3.2.8.1

ODBC for heterogeneous data sources, 4.2

OLE DB drivers for heterogeneous data sources, 4.2

operating modes

row based, 9.1.1.2

row based (target only), 9.1.1.3

selecting a default mode, 9.1.1

set based, 9.1.1.1

operator attributes, 7.6.1

operator properties

setting, 7.9

operators

connecting, 7.6

data flow, 7.3.5.2

data quality operators, 5.3

editing, 7.5

mapping

binding to repository objects, 7.4.1

Match-Merge operator, 5.3.1

Name and Address, 5.3.13

Name and Address operator, 5.3.13

synchronizing with workspace objects, 7.10

operators, mapping, 7.1

adding, 7.4

connecting, 7.6

editing, 7.5

types of, 7.3.5

optimizing the repository, 3.2.5

Oracle Heterogeneous Services, 4.2

Oracle library, 10.3.1

Oracle Transparent Gateways, 4.2

ordering

multiple targets, 9.1.6

output signature, 7.7.1.5

P

packages

as transformations, 10.2.1.2

defining, 10.4

editing, 10.5.1

process flows, 8.1.1, 8.2.2

parent identifier, 6.4.3.2.3

Partition Exchange Loading (PEL), 9.3

about, 9.3.1

configuring targets for, 9.3.5

mappings for, 9.3.2

performance considerations, 9.3.4

restrictions on, 9.3.5, 9.3.6

PeopleSoft

importing metadata, 4.7

physical names

physical name mode, 3.2.8.1

syntax for physical object names, 3.2.8.1

PL/SQL

deploying PL/SQL scripts for transparent tables, 4.9.8.2

PL/SQL code

handling existing PL/SQL code, 17

PL/SQL mappings, 9.1

PL/SQL types

about, 10.4.2.1

as transformations, 10.2.1.2

creating, 10.4.2, 10.4.2.3

editing, 10.5.2

pluggable mappings

about, 7.7

creating, 7.7.1

embedded, 7.7

reusable, 7.7

pooled tables, 4.9.2

predefined transformations, 10.2.1.1

preferences

displaying welcome pages for wizards, 3.2.5

locale, 3.2.1

message log preferences, 3.2.7

naming preferences, 3.2.8

procedures

as transformations, 10.2.1.2

defining, 10.4

editing, 10.5.1

Process Flow Editor, 8.3

process flows

about, 8.1

activities in, 8.4.1

complex conditions in, 8.8

creating, 8.2.3

defining, 8.2

deploying, 8.1.1

designing, 8

editing, 8.3

handling flat files with variable names, 18

modules, 8.1.1, 8.2.1

packages, 8.1.1, 8.2.2

transferring remote files with FTP, 19

transitions, 8.6

production

changes in, 22

projects

importing PL/SQL into, 10.6

properties

mapping, 7.8

setting, 7.9

R

RAW data type, 6.1.1

RECNUM attribute, 9.2.2

RECNUM columns, 9.2.2

records

extracting and loading master and detail records, 9.2.1.2

relationships between masters and details in flat files, 9.2.1

referential analysis, 5.2.2.3

referential integrity, ensuring in mappings, 9.1.6

reimporting

database definitions, 4.5

relating master and detail records, 9.2.1

relational data objects

creating, 6.9.1

relational implementation, 6.3

remote files

transferring, 19

remote function call (RFC), 4.9.4

RFC connection, 4.9.4.1

SAP RFC connection, 4.9.4.1

renaming

collections, 3.3.2.1

repository

optimizing, 3.2.5

requirements

for business names, 3.2.8.1

reverse engineering, 4.4

ROLAP implementation, 6.3

roles

dimension roles, 6.4.3.5

row based, 9.1.1.2

row based (target only), 9.1.1.3

row based versus set based

loading transaction data, 14

runtime performance, improving, 9

runtime, SAP, 4.9.7.2

S

sampling

master-detail flat files, 9.2.1.2

SAP

Business Domain, 4.6.1.1, 4.7.1.1, 4.8.1.2, 4.9.5.1

configuring SAP file physical properties, 4.9.7.2

defining ETL process for SAP objects, 4.9.7

defining mappings with SAP objects, 4.9.7.1

defining SAP objects, 4.9.4

loading SAP data into the workspace, 4.9.8

SAP ABAP Editor, 4.9.8

SAP application source module, 4.9.4

SAP Business Areas, 4.9.1

SAP Connector

about, 4.9

creating definitions, 4.9.4

required files, 4.9.4

SAP file physical properties

Data File Name, 4.9.7.2

File Delimiter for Staging File, 4.9.7.2

Nested Loop, 4.9.7.2

SAP System Version, 4.9.7.2

SQL Join Collapsing, 4.9.7.2

Staging File Directory, 4.9.7.2

Use Single Select, 4.9.7.2

SAP parameters

language, 4.9.7.2

loading type, 4.9.7.2

runtime, 4.9.7.2

SAP R/3

executing a SAP mapping, 4.9.8.1

importing metadata, 4.9

updating source modules, 4.9.6

SAP remote function call (SAPRFC.INI), 4.9.4

SAP table types

cluster, 4.9.2

importing, 4.9.2

pooled, 4.9.2

transparent, 4.9.2

SAPRFC.INI file, 4.9.4, 4.9.4.1, 4.9.4.1

SCDs

see slowly changing dimensions

schedules

creating, 11.5

defining, 11.5

example, 11.5.1

using, 11.5

scheduling

about, 11.4

ETL jobs, 11.2.5

set based mode, 9.1.1.1

set based update, 9.1.1.1

set based versus row based

loading transaction data, 14

set based versus row based modes, 9.1.1

setting

a starting point, 7.12.6.3

locale preferences, 3.2.1

mapping properties, 7.8

message log preferences, 3.2.7

naming preferences, 3.2.8

wizard preferences, 3.2.5

Setting the Language Parameter, 4.9.7.2

Setting the Runtime Parameter, 4.9.7.2

Siebel

importing metadata, 4.8

signatures

input, 7.7.1.4

output, 7.7.1.5

Six Sigma

metrics, 5.2.3.2

slowly changing dimensions

about, 6.5

hierarchy versioning, 6.5.2.1

type 1, 6.5.1

type 2, about, 6.5.2

type 2, updating, 6.5.2.2

type 3, 6.5.3

types, 6.5

source modules

importing definitions, 4.4.1

SAP application, 4.9.4

sources

master-detail flat file sources, 9.2.1

master-detail flat files, 9.2.1

master-detail flat files, example, 9.2.1

updating source definitions, 4.5.2

SQL*Loader

loading data from flat files, 15

starting

Data Object Editor, 6.2

starting point, setting, 7.12.6.3

surrogate identifier, 6.4.3.2.1

synchronizing

operators and workspace objects, 7.10

syntax

for business object names, 3.2.8.1

for logical object names, 3.2.8.1

for physical object names, 3.2.8.1

SYS.ANYDATA data type, 6.1.1

SYS.LCR$_ROW_RECORD data type, 6.1.1

T

tables

deploying PL/SQL scripts for transparent tables, 4.9.8.2

target load ordering, 9.1.6

target schema

designing, 6.8

rolling out changes, 21

targets

defining load orders, 9.1.6

multiple targets in a mapping, 9.1.3.1

templates

activity, 8.5

test data, defining, 7.12.3

Text String Matching, 4.6.1.1, 4.7.1.1, 4.8.1.2, 4.9.5.1

time dimensions

about, 6.6

creating, 6.9.3

creation best practices, 6.6.1

dimension attributes, 6.6.2.2

hierarchies, about, 6.6.2.4

implementing, 6.6.3

level attributes, about, 6.6.2.3

levels, about, 6.6.2.1

populating, 6.6.5

TIMESTAMP data type, 6.1.1

TIMESTAMP WITH LOCAL TIMEZONE data type, 6.1.1

TIMESTAMP WITH TIMEZONE data type, 6.1.1

transaction data

loading, 14

transferring

remote files, 19

transformation filter data, 10.6

transformation libraries

about, 10.3

accessing, 10.3.2

global shared library, 10.3.1

Oracle library, 10.3.1

types, 10.3.1

transformation properties, 10.5

transformations

about, 10.2

custom, 10.2.1.2

custom example, 10.6

importing, 10.6

introduction to, 10

names, unique, 3.2.8.1

predefined, 10.2.1.1

types of, 10.2.1

transition conditions, 8.8

Transition Editor, 8.8

transitions

conditions of, 8.8

in process flows, 8.6

transparent tables, 4.9.2

tuning

data profiling performance, 5.7

type 2 SCDs

about, 6.5.2

updating, 6.5.2.2

type 3 SCDs

about, 6.5.3

U

unique

transformation names, 3.2.8.1

updating

SAP object definitions, 4.9.6

source definitions, 4.5.2

target schema, 21

V

validating

about, 6.11

data objects, 6.11

editing invalid objects, 6.11.1

validation

about, 6.11

editing invalid objects, 6.11.1

errors, 20

VARCHAR data type, 6.1.1

VARCHAR2 data type, 6.1.1

viewing

data, 6.2.1

data objects, 6.2.1

W

wizards

Create Collection Wizard, 3.3.1

Create Data Auditor Wizard, 5.9.1

Import Metadata Wizard, 4.4.1

welcome pages, displaying, 3.2.5

X

XMLFORMAT data type, 6.1.1

XMLTYPE data type, 6.1.1