Data Object Cache Database Requirements
The data object cache database stores cached logical data objects and virtual tables for the Data Integration Service. You specify the data object cache database connection when you create the Data Integration Service.
The data object cache database supports the following database types:
- •IBM DB2 UDB
- •Microsoft SQL Server
- •Oracle
Allow 200 MB 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.
IBM DB2 Database Requirements
Use the following guidelines when you set up the repository on IBM DB2:
- •Verify that the database user account has CREATETAB and CONNECT 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.
Microsoft SQL Server Database Requirements
Use the following guidelines when you set up the repository on Microsoft SQL Server:
- •Verify that the database user account has CONNECT and CREATE TABLE privileges.
Oracle Database Requirements
Use the following guidelines when you set up the repository on Oracle:
- •Verify that the database user has the CONNECT, RESOURCE, and CREATE VIEW privileges.
- •Informatica does not support Oracle public synonyms for repository tables. Verify that public synonyms have not been created for any tables in the database.