Index

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

A

actions

about, 7.1

assigning to repository object, 7.3

defining SQL script for, 7.2

example, 7.5

functions, 7.4

overview of, 7.1

types, 7.1

assigning actions

to repository object, 7.3

authentication file

DAC, 4.2

B

best practices

columns, 5.6

configuration tags, 5.7

execution plans, 5.10

indexes, 5.5

repository objects, 5

source system containers, 5.1

subject areas, 5.9

tables, 5.4

task group, 5.3

tasks, 5.2

C

change capture

about, 11.12

filter, 11.13

columns

best practices, 5.6

configuration tags

best practices, 5.7

working with, 8.12

D

DAC

authentication file, 4.2

basic concepts, 3

first time logging in, 4.2

important features, 3.1.1

introduction, 3.1

object ownership, 3.5

process life cycle, 3.2

quick start, 4

DAC repository

command line options, 11.6

DAC server

command line access, 11.5

handling failures, 11.16

running automatically, 11.4

running two on same machine, 11.10

data flow

Online Analytical Processing (OLAP) database, about and diagram, 2.2

data warehouse

architecture, 2.2

customizing, 8.2

overview, 2.1

Data Warehouse Administration Console (DAC)

DAC features, 3.1.1

DAC window, 6.1

editable lists, 6.8

exporting metadata, 11.2

importing metadata, 11.1

menu bar, 6.2

navigation tree, 6.7

object ownership, 3.5

top pane toolbar, 6.4

user interface, 6.1

deleted records

tracking, 11.14

E

ETL

extract and load processes, 4.3

full load, 4.3

incremental load, 4.3

execution plan

micro ETL, 9.7

monitoring processes, 9.10

scheduling, 9.8

execution plans

about multi-source, 9.1.2

about single-source, 9.1.1

best practices, 5.10

building and running, 9.5

heterogeneous, about, 9.1.2

homogeneous, about, 9.1.2

micro ETL, 9.7

monitoring, 9.10

scheduling, 9.8

types of, 9.1

unit testing, 9.6

extract and load processes

common scenarios, 9.2

F

flat views

querying, 6.10.4

full load, 4.3

I

indexes

adding to data warehouse, 8.4

best practices, 5.5

Informatica

mappings, creating, 8.6

replacing workflow with SQL file, 11.7

server sessions, 11.8

Informatica repository

importing objects, 8.5

Informatica server

pointing multiple servers to single repository, 11.15

PowerCenter Services, 2.2.1

L

DAC, 4.2

M

multi-source execution plans

best practices

multi-source execution plans, 9.3

O

object

ownership, 3.5

Online Analytical Processing database

Data Warehouse, data flow into, 2.2

Oracle Business Analytics Data Warehouse

overview, 2.1

Oracle Business Analytics Warehouse

adding columns, 8.3

adding indices, 8.4

adding new table, 8.3

architecture, 2.2

architecture components, 2.2.1

customizing, 8.2

overview, 2.1

P

Parameter Management

about, 8.10

parameters

at runtime, 8.10.3

data types, 8.10.1.1

defining database specific text type parameters, 8.10.6

defining SQL type parameters, 8.10.8

defining text type parameter, 8.10.5

defining timestamp type parameters, 8.10.7

nesting, 8.10.4

overview, 8.10.1

preconfigured, 8.10.2

Q

query functionality

flat views querying, 6.10.4

query commands, 6.10.1

query operators, 6.10.1

query procedures, 6.10.3

R

refresh dates

about, 9.9

repository objects

best practices, 5

right-click menu

common commands, 6.5.1

Design view commands, 6.5.2

Execute view commands, 6.5.4

Setup view commands, 6.5.3

S

source system container

about, 3.3

best practices, 5.1

copying, 8.1

creating, 8.1

DAC Repository objects, 3.4

SQL script

defining, 7.2

subject area

customizing, 8

designing, 8.13

subject areas

best practices, 5.9

T

tables

adding new tables, 8.3

best practices, 5.4

truncate behavior, multi-source ETL, 9.2.2.1

truncate behavior, single-source ETL, 9.2.1.1

tablespaces

specifying for indexes by table type, 8.11

task group

best practices, 5.3

creating, 8.9

task phase dependency

setting, 8.8, 8.8

Tasks

creating tasks for workflows, 8.7

tasks

best practices, 5.2

U

upgrade

Upgrade/Merge Wizard, 10.1

Upgrade/Merge Wizard

about, 10.1

Difference Report, 10.8.1

major stages of upgrade/merge, 10.1

Peer to Peer Merge option, 10.7

Refresh Base option, 10.5

Refresh Base upgrade option, 10.4

Replace Base option, 10.6

Repository Upgrade (DAC 784) option, 10.3

resetting, 10.1.2

resolving object differences, 10.8

upgrade/merge options, 10.2

user account

about, 4.1

creating, deleting, inactivation, 4.1.1

management, 4.1