Bookshelf Home | Contents | Index | Search | PDF

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

 

A

Administrator Workstation

installation planning overview  1

PowerMart Client, installing on  1

regional language settings, changing  1

server component  1

 1

ANSI NULL option, setting  1

audience for guide  1

Back to top

---

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

Back to top

---

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

Back to top

---

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

Back to top

---

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

 1

ETL alignment version system preferences, changing  1

 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

Back to top

---

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

Back to top

---

G

guide

audience for  1

organization of  1

revision history  1

Back to top

---

H

hierarchical relationships, invalid hierarchy exceptions, about  1

history, revision history  1

Back to top

---

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

Back to top

---

J

Japanese users, about running the Informatica Server  1

Back to top

---

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

Back to top

---

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

Back to top

---

O

ODBCSQL utility, using to drop indexes  1

 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

 1

Outlook

closes when finishing ETL process, probable cause  1

error when sending post session email  1

Back to top

---

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

 1

Back to top

---

Q

Query Analyzer, can not open after installing ODBC driver  1

Back to top

---

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

 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

Back to top

---

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

 1

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

Back to top

---

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

Back to top

---

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

Back to top

---

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

Back to top

Bookshelf Home | Contents | Index | Search | PDF