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, 16
- navigation tree, 2.6.7
- object ownership, 2.5
- top pane toolbar, 2.6.4, 16
- 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, 16
- Design view commands, 16
- Execute view commands, 16
- Setup view commands, 16
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