Announcement: New Design for docs.informatica.com!
We have updated the look and feel of docs.informatica.com. To load the latest design, press CTRL-F5 to clear the pages you previously cached on our site, or simply restart your browser.
Use the following guidelines when you set up the repository:
Specify the database schema name when you use Microsoft SQL Server as the Model Repository database.
Set the allow snapshot isolation and read committed isolation level to ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to minimize locking contention.
To set the isolation level for the database, run the following commands:
ALTER DATABASE
DatabaseName
SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE
DatabaseName
SET READ_COMMITTED_SNAPSHOT ON
To verify that the isolation level for the database is correct, run the following commands:
SELECT snapshot_isolation_state FROM sys.databases WHERE name=[DatabaseName]
SELECT is_read_committed_snapshot_on FROM sys.databases WHERE name =
DatabaseName
The database user account must have the CONNECT, CREATE TABLE, and CREATE VIEW privileges.