Profiling Warehouse Requirements
The profiling warehouse database stores profiling and scorecard results. You specify the profiling warehouse connection when you create the Data Integration Service.
The profiling warehouse supports the following database types:
- •IBM DB2 UDB
- •Microsoft SQL Server
- •Oracle
Allow 10 GB of disk space for the database.
Note: Ensure that you install the database client on the machine on which you want to run the Data Integration Service. You can specify a JDBC connection as the profiling warehouse connection for IBM DB2 UDB, Microsoft SQL Server, and Oracle database types.
For more information about configuring the database, see the documentation for your database system.
IBM DB2 Database Requirements
Use the following guidelines when you set up the repository on IBM DB2:
- •The database user account must have the CREATETAB, CONNECT, CREATE VIEW, and CREATE FUNCTION privileges.
- •Informatica does not support IBM DB2 table aliases for repository tables. Verify that table aliases have not been created for any tables in the database.
- •Set the tablespace pageSize parameter to 32768 bytes.
- •Set the NPAGES parameter to at least 5000. The NPAGES parameter determines the number of pages in the tablespace.
Note: Informatica does not support the partitioned database environment for IBM DB2 databases when you use a JDBC connection as the profiling warehouse connection.
Microsoft SQL Server Database Requirements
Use the following guidelines when you set up the repository:
- •The database user account must have the CONNECT, CREATE TABLE, CREATE VIEW, and CREATE FUNCTION privileges.
Oracle Database Requirements
Use the following guidelines when you set up the repository on Oracle:
- • Verify that the database user has the following privileges:
- - ALTER TABLE
- - CREATE ANY INDEX
- - CREATE PROCEDURE
- - CREATE SESSION
- - CREATE TABLE
- - CREATE VIEW
- - DROP TABLE
- - UPDATE TABLE
- •Informatica does not support Oracle public synonyms for repository tables. Verify that public synonyms have not been created for any tables in the database.
- •Set the following parameters to the Informatica recommended values:
Parameter | Recommended Value |
|---|
open_cursors | 4000 |
Sessions | 1000 |
Processes | 1000 |