Skip Headers
Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Data Warehouse Administration Console
11g Release 1 (11.1.1)

Part Number E14849-07
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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