Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
A
Administrator Workstation
installation planning overview 1
PowerMart Client, installing on 1
regional language settings, changing 1
server component 1
ANSI NULL option, setting 1
audience for guide 1
B
batch processes, modifying for industry applications
See also Linking Batches
about batching processes and list of industry applications 1
industries and sessions (table) 1
session, removing from a batch process 1
batches
See also Modifying the Batch Processes for Industry Applications
consecutive batches, about running 1
custom batches, creating 1
environment variables, setting up 1
error message when executing on the Informatica Server Manager, probable cause 1
extraction, disabling after performing 1
linking batches example 1
Server Manager error message, probable cause 1
bulkload mode, error while creating a custom session 1
C
circular hierarchy exceptions, about and example 1
Code Page 1252, about running the Informatica Server 1
computer names and components (table) 1
Cost List exceptions
See also Understanding Exceptions
about and example 1
Cost lists, using to display 1
products without a cost list 1
currency, diagnosing translation issues 1
custom folder, working with 1
D
data flow
OLTP to OLAP, diagram 1
Online Analytical Processing (OLAP) database, about and diagram 1
data import
data loading matrix, table of 1
syndicated data loading, overview 1
data loading
See also Data Loading Issues
Siebel Analytics for Life Sciences, issues when loading 1
troubleshooting, Informatica and data loading issues 1
Data Loading Matrix
Informatica Metadata Reporter (IMR), about and use 1
table of 1
Data Source Matrix, table of 1
Data Warehouse Server
See also Configuring the Informatica Server Under Windows
installation overview 1
registry settings, changing in UNIX 1
server component 1
database connections, creating
DB2 installations, creating database connections for 1
native and ODBC connection (diagram) 1
ODBC connection information, table of 1
Oracle installation, creating database connections for 1
DB Library Options setting, modifying 1
DB2
database connections, creating for 1
Siebel Data Warehouse requirements 1
Siebel Data Warehouse, cannot connect to 1
DB2 running under OS/390
components, about 1
Informatica repository, configuring 1
Informatica repository, installing 1
installation prerequisites 1
star schema tables, installing 1
ddlimp utility, using to recreate indexes 1
dimension
new dimension, guidelines for creating new facts 1
new dimension, guides for creating and using it in an existing fact 1
documentation
required reading 1
third-party, table of 1
E
EAI, about using for populating Siebel Data Warehouse 1
email notification, Outlook error when sending post session email 1
Enterprise Manager, error displayed after installing ODBC driver 1
environment variables, setting up 1
ETL alignment version system preferences, changing 1
ETL History view, using to view the history of the ETL processes and statuses 1
ETL process
See also Design the ETL Process
custom batches, creating 1
custom folder, working with 1
custom templates, using 1
described and customizing 1
designing 1
starting 1
troubleshooting 1
exception reports
See also Understanding Exceptions
additional exceptions, list of 1
circular hierarchy exceptions, about and example 1
cleansing the data, process and diagram 1
ETL History view, using to view the history of the ETL processes and statuses 1
exception report components, list of 1
exception, fixing 1
exchange rate exceptions, about 1
Exchange Rate view, using to diagnose currency translation issues 1
executing the report, cleansing steps 1
invalid hierarchy exceptions, about 1
List of Values exceptions 1
List of Values view, using to compare values with Siebel Data Warehouse 1
exchange rate exceptions, about 1
Exchange Rate view, using to diagnose currency issues 1
F
fact
existing fact, guidelines for creating a new dimension and using it in 1
new fact, guidelines for creating 1
new fact, guidelines for creating a new dimension 1
Full_Extract_Siebel_DW, error returned by Informatica 1
Full_Load_Siebel_DW
error when running 1
improving performance of 1
indexes, dropping before running 1
indexes, recreating 1
Full_Load_Siebel_DW_Facts, error message when executing 1
G
guide
audience for 1
organization of 1
revision history 1
H
hierarchical relationships, invalid hierarchy exceptions, about 1
history, revision history 1
I
Informatica .rep file name 1
Informatica client software
configuring (procedure) 1
Enable Data Code Pages Validation, checking if conditions met 1
PowerMart Client, installing on the Administrator Workstation 1
Informatica Metadata Reporter (IMR)
about and use 1
error when running, probable cause 1
Informatica PowerMart Client, installing on the Administrator Workstation 1
Informatica Repository Manager
See also Administering the Informatica Repository
configuring, when installing 1
configuring, when starting 1
Informatica Repository, administering
See also Administering the Informatica Repository
about 1
batches, disabling after performing an extraction 1
Data Warehouse Server registry setting in Windows, changing 1
Data Warehouse Server registry settings, changing in UNIX 1
DB2 running under OS/390, configuring for 1
DB2 running under OS/390, installing on 1
Dimension, Fact, and SCD batches, disabling 1
ETL process, monitoring 1
ETL process, starting 1
full load, doing 1
refreshing load, doing in Oracle 1
Siebel Data Warehouse had loaded, verifying 1
status of the request, checking to start the batch 1
troubleshooting ETL process 1
Informatica Server
See also Configuring Informatica Server
Code Page 1252, running on operating systems using 1
database connection, configuring 1
installing on other than default location 1
Informatica Server and repository, configuring
See also Installing Informatica Client Software
configuring (procedure) 1
Informatica client, configuring 1
Informatica Repository Manager, configuring 1
Informatica repository, configuring 1
Informatica Server database connection, configuring 1
Informatica Server host name, changing 1
Informatica Server host name, verifying the change 1
special cases, notes on 1
Unicode mode, about running 1
Unicode mode, configuring under Windows 1
UNIX, setting environment variables 1
Windows, configuring under 1
Windows, setting up Informatica service under 1
Informatica Server host name
See also Changing the Informatica Server Host Name
changing 1
verifying that it has been changed 1
Informatica Service, unable to start on Windows 1
installation
See also Prerequisites for Installing DB2 under OS/390
Informatica client software 1
Informatica Server, installing on other than default directory 1
materials provided (table) 1
planning 1
Siebel eBusiness 6.3 to 7.5 Analytics Bridge 1
Siebel ePharma 6.3 to 7.5 Analytics Bridge 1
troubleshooting issues 1
J
Japanese users, about running the Informatica Server 1
L
List of Values
exceptions, about and example 1
view, using to compare values with the Siebel Data Warehouse 1
loads, refreshing 1
LS dimension tables, supported incremental updates (table) 1
M
Mandatory Id fields, description 1
materials provided, table of 1
Microsoft Outlook
closes when finishing ETL process, probable cause 1
error when sending post session email 1
mobile Web users, about synchronizing before running load 1
O
ODBCSQL utility, using to drop indexes 1
Online Analytical Processing database
about 1
Data Warehouse, data flow into 1
note, about creation of db 1
Star Matrix, ePharma 6.3 to 7.5 (table) 1
Online Transaction Processing database
See also Siebel Application 6.3 OLTP Update Patch
Online Analytical Processing database, differences from 1
OPB_OBJECT_LOCKS Informatica session deadlocked, probable cause 1
Oracle
database connections, creating for 1
full load optimizer settings 1
mappings hang, probable cause 1
predefined full load batch process (table) 1
predefined refresh batch processes (table) 1
refresh load, doing 1
Siebel Data Warehouse requirements 1
Unicode database, about changing the Informatica Server host name 1
organization of guide 1
Outlook
closes when finishing ETL process, probable cause 1
error when sending post session email 1
P
parent-child relationship, circular hierarchy exceptions 1
performance
components configured to optimize performance 1
Full_Load_Siebel_DW, improving performance of 1
plan types, data loading matrix value 1
PowerMart Client, installing on the Administrator Workstation 1
Q
Query Analyzer, can not open after installing ODBC driver 1
R
RDBMS error message, probable cause 1
reading, required 1
rebuilding Siebel Data Warehouse 1
refresh loads 1
Refresh_Extract_Siebel_DW
error returned by Informatica 1
regional setting, changing 1
.rep file, Informatica file 1
repository
Siebel 7,5, modifications for Analytics Bridge 1
requirements, Siebel Data Warehouse 1
responsibilities
7.5 responsibilities, adding to 6.3 ePharma users 1
ePharma responsibilities and functions (table) 1
Restart Sessions, using in case of failure 1
revision history 1
S
S_SYND_DATA attribute by data source matrix, table of 1
SDE_RecordLoadStart session fails, probable cause 1
SDEINC_RecordExtractStart session fails, probable cause 1
seed data, importing Locale seed data into the OLTP database 1
server component software
See also Server and Client Configuration
computer names and server components (table) 1
configuration, recommended 1
server components, installation requirements
See also Siebel Data Warehouse Requirements
Siebel Data Warehouse, about 1
Windows NT, additional Data Warehouse server requirements 1
session, removing from batch process 1
Siebel 7.5
repository modifications for Analytics Bridge 1
responsibilities, adding to 6.3 ePharma users 1
Star Matrix, ePharma 6.3 to 7.5 (table) 1
Siebel Analytics for Life Sciences
data loading issues 1
LS dimension tables, supported incremental updates (table) 1
Siebel Application 6.3 OLTP update patch
about 1
Analytics Bridge, files required (table) 1
Informatica directory, copying update patch files into 1
installation directory, location of 1
update patch files, setting up 1
Siebel Data Warehouse
See also Extending the Siebel Data Warehouse
DB2 requirements 1
loaded, verifying 1
multiple instances, about creating 1
Oracle requirements 1
rebuilding 1
requirements 1
SQL server-specific requirements 1
star schemas, creating or adding columns to 1
troubleshooting configuration issues 1
Siebel Data Warehouse, modifying
See also Extending the Siebel Data Warehouse
about 1
ETL process description 1
ETL process, designing 1
rebuilding Data Warehouse 1
source fields, identifying 1
tables, adding fields to 1
Siebel Data Warehouse, populating
See also Populating the Initial Siebel Data Warehouse
about 1
full load optimizer settings in Oracle 1
predefined full load batch processing in Oracle (table) 1
predefined refresh batch processes in Oracle (table) 1
Siebel Data Warehouse, setting up
See also Setting Up the Siebel Data Warehouse
components and about setting up 1
system variables 1
Siebel Delivers/Scheduler, creating database tables for 1
Siebel eBusiness 6.3 to 7.5 Analytics Bridge
Analytics Bridge files (table) 1
Configuration Setup screen, pausing when displayed 1
Informatica .rep file name 1
Informatica repository file, replacing 1
installation process overview 1
OLTP schema definitions, importing new definitions 1
physical database, applying schema definitions to 1
seed data, importing language-independent seed data 1
seed data, importing Locale seed data 1
Siebel Analytics 7.5, beginning standard installation 1
Siebel Analytics repository file, replacing 1
Siebel Analytics users, creating 1
Siebel Delivers/Schedules, creating database tables for 1
Siebel ePharma
data loading matrix, table of 1
Siebel ePharma 6.3 to 7.5 Analytics Bridge
7.5 Siebel Analytics responsibilities, adding to 6.3 users 1
7.5 Star Matrix, ePharma 6.3 to 7.5 (table) 1
about 1
Analytics Bridge installation 1
Authentication block definitions, changing 1
Authorization Properties block, changing 1
ePharma responsibilities and functions (table) 1
ETL alignment version system preferences, changing 1
Login property changes 1
Siebel Analytics 7.5 repository modifications, about 1
Siebel Application 6.3 OLTP update patch 1
Siebel Server
See also The Siebel Server
installation planning overview 1
server components 1
Siebel Transaction Database
connection error 1
connections required 1
Cost lists, displaying 1
extracting information from 1
Siebel Data Warehouse, differences from 1
source fields, identifying 1
source fields, identifying 1
SQL Server
DB Library Options setting, modifying 1
Siebel Data Warehouse requirements 1
star schemas
columns, adding 1
creating new 1
DB2 running under OS/390, installing for 1
synchronizing mobile users before running load, about 1
syndicated data
importing, overview 1
table (S_SYND_DATA), attribute fields 1
system preferences
See also Understanding Exceptions
navigating to 1
table of 1
system variables, changing 1
T
tablespace, Oracle-specific requirements 1
Technical Note 429, about problems using Analytics Bridge 1
templates, using custom templates
columns in the Siebel Data Warehouse, guidelines for modifying 1
custom templates, description of 1
extra columns, guidelines for adding from a related source table 1
extra columns, guidelines for adding from the same source table 1
new dimension, guidelines for creating and using it in an existing fact 1
new dimension, guidelines for creating new facts 1
new fact, guidelines for creating 1
third-party documentation, table of 1
troubleshooting
ETL process 1
Informatica and data loading issues 1
installation and configuration issues 1
U
Unicode mode
multibyte or ISO 8859-1, about running Informatica Server in 1
Windows, configuring under 1
UNIX
Informatica Server, setting environment variables 1
installation of Informatica software, about installing from CD-ROM 1
W
Web Server
installation planning overview 1
sever components 1
Windows
See also Troubleshooting the ETL Process
Data Warehouse Server registry settings, changing 1
Informatica Server, configuring under 1
Informatica Server, setting up under 1
Unicode mode, configuring under Windows 1
Windows NT
See also Troubleshooting the ETL Process
Data Warehouse server requirements, additional 1
Primary Domain Controller and Backup Domain Controller, support of 1
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide, Version 7.5, Rev. C Published: 18 April 2003 |