Index

A B C D E F H I M O P Q R S T U W

A

actions

about, 7.11

assigning to repository object, 7.11.2

defining SQL script for, 7.11.1

example, 7.11.4

functions, 7.11.3

overview of, 7.11

types, 7.11

administrator

logging into DAC, 4.3

tasks and concepts, 4

architecture

overview, 2.1

ASCII Data Movement Mode

how to set, 4.7.11

assigning actions

to repository object, 7.11.2

authentication file, 4.2

modifying, 4.16

authentication modes, 4.1

B

best practices

columns, 7.1.6

configuration tags, 7.1.7

execution plans, 7.1.10

indexes, 7.1.5

repository objects, 7.1

source system containers, 7.1.1

subject areas, 7.1.9

tables, 7.1.4

task group, 7.1.3

tasks, 7.1.2

C

certification information, Preface

code page validation, relaxed, 4.7.11

columns

best practices, 7.1.6

command line parameters

DAC repository, 13.2

configuration tags

best practices, 7.1.7

working with, 7.10

D

DAC

architecture overview, 2.1

authentication file, 4.2

authentication modes, 4.1

external executor, integrating, 14

heuristics, using, 11.3

integrating with BI Server, 4.8

logging into as DAC user, 5.1

object ownership, 2.5

performance tuning, 11

process life cycle, 2.2.2

quick start, 5

setting up communication with Informatica, 4.7

setting up system properties, 4.9

starting and stopping the server, 4.4.5

DAC metadata

distributing, 4.11

DAC metadata patches

working with, 12

DAC parameters

defining, 8.3

DAC repository

command line options, 13.2

command line parameters, 13.2

configuring DAC Server connection, 4.4.3

encryption key, changing, 4.15

DAC Server

accessing, 4.4.1

accessing through command line, 13.1

high-availability, 4.4.2

managing, 4.4

monitoring using MBean Browser, 13.8

monitoring using WebLogic Server., 13.9

starting and stopping, 4.4.5

starting and stopping manually, 4.4.5

DAC server

command line access, 13.1

running automatically, 13.3

running two on same machine, 13.4

DAC user accounts

managing, 4.14

DAC variables

about, 8.2

Data Movement Mode

how to set, 4.7.11

data warehouse

customizing, 7.2

managing schemas, 10

resetting, 13.7

Data Warehouse Administration Console (DAC)

DAC window, 2.6.1

editable lists, 2.6.8

exporting metadata, 4.11.1

importing metadata, 4.11.2

menu bar, 2.6.2, 17

navigation tree, 2.6.7

object ownership, 2.5

top pane toolbar, 2.6.4, 17

user interface, 2.6.1

databases,supported, Preface

DataMovementMode

how to set, 4.7.11

E

email notifications

setting up, 4.4.7

encryption key

changing, 4.15

recovering from lost key, A.1

ETL processes

customizing, 7

execution plan

micro ETL, 6.4

monitoring processes, 5.4

scheduling, 5.5

execution plans

about multi-source, 6.3

about single-source, 6.2

best practices, 7.1.10

build process rules, 6.5

building and running, 6.6, 6.6

considerations for multi sources, 6.3.1

heterogeneous, about, 6.3

homogeneous, about, 6.3

introduction to, 6.1

micro ETL, 6.4

monitoring, 5.4

restarting upon failure, 5.4.4

running, 5.2

running concurrently, 6.7

scheduling, 5.5

setting up data source notifications, 6.9

setting up event delays, 6.9

setting up extract delays, 6.9

starting, 6.10

unit testing tasks, 5.6

external executors

integrating with DAC, 14

F

flat views

querying, 2.6.10.4

H

heuristics, 11.3

I

incremental load strategy

about, 5.7

indexes

adding to data warehouse, 7.4

best practices, 7.1.5

managing, 11.1

Informatica

communication with DAC, 4.7

creating repository administrator, 4.7.10

high availability, 4.4.2.2

mappings, creating, 7.6

native security domain, 4.7.10

server sessions, 4.7.7

setting Integration Services custom properties, 4.7.9

setting relaxes code page validation, 4.7.8

Informatica PowerCenter Integration Services

setting relaxes code page validation, 4.7.11

Informatica repository

importing objects, 7.5

Informatica server

pointing multiple servers to single repository, 13.6

M

memory requirements, Preface

minimum disk space, Preface

O

operating systems, supported, Preface

Oracle Business Analytics Warehouse

adding columns, 7.3

adding indices, 7.4

adding new table, 7.3

customizing, 7.2

P

parameters

at runtime, 8.1.2

data types, 8.1.4

defining database specific text type parameters, 8.3.2

defining SQL type parameters, 8.3.4

defining text type parameter, 8.3.1

defining timestamp type parameters, 8.3.3

nesting, 8.1.7

overview, 8.1

preconfigured, 8.1.6

patches

working with, 12

physical data sources

setting up, 4.5

platforms, supported, Preface

Q

query functionality

flat views querying, 2.6.10.4

query commands, 2.6.10.1

query operators, 2.6.10.1

query procedures, 2.6.10.3

R

refresh dates

about, 5.7

adding, 5.7.2

computing timestamps, 5.7.3

relaxed code page validation, 4.7.11

repository object

ownership, 2.5

repository objects

best practices, 7.1

requirements, system, Preface

right-click menu

common commands, 17

Design view commands, 17

Execute view commands, 17

Setup view commands, 17

S

security

client requirements, 1.2

Fusion Middleware mode, 1.3

overview, 1.1

recommended setup, 1.5

standalone mode, 1.4

source system container

about, 2.3

best practices, 7.1.1

copying, 5.3

creating, 5.3

creating or copying, 5.3

DAC Repository objects, 2.4

SQL script

defining, 7.11.1

starting the DAC Server, 4.4.5

subject areas

best practices, 7.1.9

creating, 9.3

designing, 9

how DAC determines tasks for, 9.2

when to reassemble, 9.5

supported installation types, Preface

system properties

setting up, 4.9

system requirements, Preface

T

tables

adding new tables, 7.3

best practices, 7.1.4

tablespaces

specifying for indexes by table type, 11.1.2

task group

best practices, 7.1.3

creating, 7.9

task phase dependency

setting, 7.8, 7.8

tasks

best practices, 7.1.2

creating tasks for workflows, 7.7

execution and queue management, 2.2.1

identifying failure, 5.4.3

viewing life span, 5.4.2

U

Unicode Data Movement Mode

how to set, 4.7.11

unit testing tasks, 5.6

Upgrade/Merge Wizard

Difference Report, 15.9.1

Peer to Peer Merge option, 15.8

Refresh Base option, 15.6

Refresh Base upgrade option, 15.5

Replace Base option, 15.7

Repository Upgrade (DAC 784) option, 15.4

resetting, 15.2

resolving object differences, 15.9

upgrade/merge options, 15.3

user account

managing, 4.14.2

W

What's New, Preface

workflows

looping, 11.4