D Database-Specific Parameter Settings for the reset_infa_seq_gen.bat File

This appendix contains the following topic:

• Section D.1, "Database-Specific Parameter Settings for the reset_infa_seq_gen.bat File"

D.1 Database-Specific Parameter Settings for the reset_infa_seq_gen.bat File

Use the reset_infa_seq_gen.bat script to initialize the Informatica sequence generator for incremental runs on the Upgrade repository.

The reset_infa_seq_gen.bat file requires you to enter database-specific parameter values. This section includes parameter settings for the following databases:

• Table D-1, "Oracle Database Parameter Settings for reset_infa_seq_gen.bat"

• Table D-2, "SQL Server Database Parameter Settings for reset_infa_seq_gen.bat"

• Table D-3, "IBM DB2 Database Parameter Settings for reset_infa_seq_gen.bat"

Oracle Database Parameter Settings

Table D-1 Oracle Database Parameter Settings for reset_infa_seq_gen.bat

Parameter	Setting
OLAP USERNAME	Enter the data warehouse database user ID.
OLAP PASSWORD	Enter the user ID/password@connection string of the data warehouse database.
INFORMATICA DB USERNAME	Enter the user ID of the Upgrade Informatica Repository database.
INFORMATICA DB PASSWORD	Enter the password@connection string of the Upgrade InformaticaRepository database.
INFORMATICA REPOSITORY	Enter the name of the Upgrade Informatica Repository.
INFORMATICA REPOSITORY USERNAME	Enter the user ID of the Upgrade Informatica Repository.
INFORMATICA REPOSITORY PASSWORD	Enter the password for the Upgrade Informatica Repository.
INFORMATICA REPOSITORY SERVER ADDRESS	Enter the name of the machine that runs the Repository Service for the Upgrade Repository.
INFA_PORT	Enter the port number for the Repository Service. The default is 6001.
INFA_FODLER	Enter the value UPGRADE.

SQL Server Database Parameter Settings

Table D-2 SQL Server Database Parameter Settings for reset_infa_seq_gen.bat

Parameter	Setting
OLAP_SERVER	Enter the name of the SQL Server for the OLAP database.
OLAP DATABASE	Enter the name of the database on which OLAP data is available.
OLAP USERNAME	Enter the user ID of the data warehouse database.
OLAP PASSWORD	Enter the user ID/password@connection string of the data warehouse database.
INFORMATICA SERVER ADDRESS	Enter the name of the SQL Server for the Informatica Repository database.
INFORMATICA DATABASE	Enter the name of the database in which the Informatica Repository metadata is available.
INFORMATICA DB USERNAME	Enter the user ID of the Upgrade Informatica Repository database.
INFORMATICA DB PASSWORD	Enter the password @connection string of the Upgrade Informatica Repository database.
INFORMATICA REPOSITORY	Enter the name of the Upgrade Informatica Repository.
INFORMATICA REPOSITORY USERNAME	Enter the user ID of the Upgrade Informatica Repository.
INFORMATICA REPOSITORY PASSWORD	Enter the password of the Upgrade Informatica Repository.
INFORMATICA REPOSITORY SERVER ADDRESS	Enter the name of the machine that runs the Repository Service for the Upgrade Repository.
INFA_PORT	Enter the port number for the Repository Service. The default is 6001.
INFA_FOLDER	Enter the value UPGRADE.

IBM DB2 Database Parameter Settings

Table D-3 IBM DB2 Database Parameter Settings for reset_infa_seq_gen.bat

Parameter	Setting
OLAP USERNAME	Enter the user ID of the data warehouse database.
OLAP PASSWORD	Enter the user ID/password@connection string of the data warehouse database.
INFORMATICA DB USERNAME	Enter the user ID of the Upgrade Informatica Repository database.
INFORMATICA DB PASSWORD	Enter the password @connection string of the Upgrade Informatica Repository database.
INFA DATABASE ALIAS	Enter the name of the database in which Informatica Repository metadata is available.
INFORMATICA REPOSITORY	Enter the name of the Upgrade Informatica Repository.
INFORMATICA REPOSITORY USERNAME	Enter the user ID of the Upgrade Informatica Repository.
INFORMATICA REPOSITORY PASSWORD	Enter the password for the Informatica Repository.
INFORMATICA REPOSITORY SERVER ADDRESS	Enter the name of the machine that runs the Repository Service for the Upgrade Repository.
INFA_PORT	Enter the port number for the Repository Service. The default is 6001.
INFA_FOLDER	Enter the value UPGRADE.