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

This appendix contains the following topics:

• Section E.1, "Running the reset_infa_seq_gen.bat File on the Base Informatica Repository"

• Section E.2, "Running the reset_infa_seq_gen.bat File on the Upgrade Informatica Repository"

E.1 Running the reset_infa_seq_gen.bat File on the Base Informatica Repository

This section contains the following topics:

• Section E.1.1, "Entering Values for the reset_infa_seq_gen.bat File on the Base Informatica Repository"

• Section E.1.2, "Obtaining ROW_WID from W_ORG_D"

E.1.1 Entering Values for the reset_infa_seq_gen.bat File on the Base Informatica Repository

Follow this procedure to enter values for the reset_infa_seq_gen.bat file to initialize the Informatica sequence generator for incremental runs on the base Informatica Repository (for example, Oracle_BI_DW_Base.rep).

1. Navigate to OracleBI\dwrep\Upgrade\DbScripts\<database type>.

2. Open the reset_infa_seq_gen.bat file.

3. Enter the appropriate parameter values to reflect your environment (the parameters are database specific). See one of the following tables:

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

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

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

• Table E-4, "Teradata Database Parameter Settings for reset_infa_seq_gen.bat"

After you complete this step, proceed to Section E.1.2, "Obtaining ROW_WID from W_ORG_D." Do not execute reset_infa_seq_gen.bat until you have completed the procedure in Section E.1.2, "Obtaining ROW_WID from W_ORG_D."

Oracle Database Parameter Settings for the Base Informatica Repository

Table E-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 SERVER ADDRESS	Enter the Informatica Server host address.
INFORMATICA DATABASE TNSENTRY	Enter the TNS entry for the Informatica Server database.
INFORMATICA DB USERNAME	Enter the user ID of the base Informatica Repository database.
INFORMATICA DB PASSWORD	Enter the password@connection string of the base InformaticaRepository database.
INFORMATICA REPOSITORY	Enter the name of the base Informatica Repository.
INFORMATICA REPOSITORY USERNAME	Enter the user ID of the base Informatica Repository.
INFORMATICA REPOSITORY PASSWORD	Enter the password for the base Informatica Repository.
INFORMATICA FODLER	For all source systems except Siebel Industry Applications, enter the value HOR. For Siebel Industry Applications, you need to run reset_infa_seq_gen.bat twice. For the first execution, enter the value VERT. For the second execution, enter the value HOR.
INFORMATICA PORT	Enter the port number for the Repository Service. The default is 6001.

SQL Server Database Parameter Settings for the Base Informatica Repository

Table E-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 DB SERVER ADDRESS	Enter the Informatica Server host address.
INFORMATICA DATABASE	Enter the name of the database in which the base Informatica Repository metadata is available.
INFORMATICA DB USERNAME	Enter the user ID of the base Informatica Repository database.
INFORMATICA DB PASSWORD	Enter the password @connection string of the base Informatica Repository database.
INFORMATICA REPOSITORY SERVER ADDRESS	Enter the name of the machine that runs the Repository Service for the base Repository.
INFORMATICA REPOSITORY USERNAME	Enter the user ID of the base Informatica Repository.
INFORMATICA REPOSITORY PASSWORD	Enter the password of the base Informatica Repository.
INFORMATAICA FOLDER	For all source systems except Siebel Industry Applications, enter the value HOR. For Siebel Industry Applications, you need to run reset_infa_seq_gen.bat twice. For the first execution, enter the value VERT. For the second execution, enter the value HOR.
INFORMATICA PORT	Enter the port number for the Repository Service. The default is 6001.

IBM DB2 Database Parameter Settings for the Base Informatica Repository

Table E-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.
INFA DATABASE ALIAS	Enter the name of the database in which Informatica Repository metadata is available.
INFORMATICA DB USERNAME	Enter the user ID of the base Informatica Repository database.
INFORMATICA DB PASSWORD	Enter the password @connection string of the base Informatica Repository database.
INFORMATICA REPOSITORY	Enter the name of the base Informatica Repository.
INFORMATICA REPOSITORY USERNAME	Enter the user ID of the base Informatica Repository.
INFORMATICA REPOSITORY PASSWORD	Enter the password for the base Informatica Repository.
INFORMATICA SERVER ADDRESS	Enter the Informatica Server host address.
INFORMATICA FOLDER	For all source systems except Siebel Industry Applications, enter the value HOR. For Siebel Industry Applications, you need to run reset_infa_seq_gen.bat twice. For the first execution, enter the value VERT. For the second execution, enter the value HOR.
INFORMATICA PORT	Enter the port number for the Repository Service. The default is 6001.

Teradata Database Parameter Settings for the Base Informatica Repository

Table E-4 Teradata Database Parameter Settings for reset_infa_seq_gen.bat

Parameter	Setting
OLAP_SERVER	Enter the name of the Teradata 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 password of the data warehouse database.
INFORMATICA SERVER ADDRESS	Enter the Informatica Server host address.
INFORMATICA DB USERNAME	Enter the user ID of the base Informatica Repository database.
INFORMATICA DB PASSWORD	Enter the password @connection string of the base Informatica Repository database.
INFORMATICA REPOSITORY	Enter the name of the base Informatica Repository.
INFORMATICA REPOSITORY USERNAME	Enter the user ID of the base Informatica Repository.
INFORMATICA REPOSITORY PASSWORD	Enter the password for the base Informatica Repository.
INFORMATICA FOLDER	For all source systems except Siebel Industry Applications, enter the value HOR. For Siebel Industry Applications, you need to run reset_infa_seq_gen.bat twice. For the first execution, enter the value VERT. For the second execution, enter the value HOR.
INFORMATICA PORT	Enter the port number for the Repository Service. The default is 6001.

E.1.2 Obtaining ROW_WID from W_ORG_D

Follow this procedure to obtain the maximum ROW_WID value from W_ORG_D.

1. In the reset_infa_seq_gen.bat file, go to the end of the file and locate the section similar to:

   IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
   

2. In the code example, note the value 1234567. You will replace this value in a following step.

3. On the data warehouse, run the following SQL statement:

   SELECT MAX(ROW_WID)+1 FROM W_ORG_D
   

4. In the reset_infa_seq_gen.bat file, replace the value 1234567 with the value that was returned by the SQL statement.

5. Execute reset_infa_seq_gen.bat.

E.2 Running the reset_infa_seq_gen.bat File on the Upgrade Informatica Repository

Follow this procedure to run the reset_infa_seq_gen.bat file to initialize the Informatica sequence generator for incremental runs on the Upgrade repository.

1. Navigate to OracleBI\dwrep\Upgrade\DbScripts\<database type>.

2. Open the reset_infa_seq_gen.bat file.

3. Enter the appropriate parameter values to reflect your environment (the parameters are database specific). See one of the following tables:

• Table E-5, "Oracle Database Parameter Settings for reset_infa_seq_gen.bat"

• Table E-6, "SQL Server Database Parameter Settings for reset_infa_seq_gen.bat"

• Table E-7, "IBM DB2 Database Parameter Settings for reset_infa_seq_gen.bat"

• Table E-8, "Teradata Database Parameter Settings for reset_infa_seq_gen.bat"

Oracle Database Parameter Settings for the Upgrade Informatica Repository

Table E-5 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 SERVER ADDRESS	Enter the Informatica Server host address.
INFORMATICA DATABASE TNSENTRY	Enter the TNS entry for the Informatica Server 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 FODLER	Enter the value UPGRADE
INFORMATICA PORT	Enter the port number for the Repository Service. The default is 6001.

SQL Server Database Parameter Settings for the Upgrade Informatica Repository

Table E-6 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 DB SERVER ADDRESS	Enter the Informatica Server host address.
INFORMATICA DATABASE	Enter the name of the database in which the upgrade 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 SERVER ADDRESS	Enter the name of the machine that runs the Repository Service for the upgrade Repository.
INFORMATICA REPOSITORY USERNAME	Enter the user ID of the upgrade Informatica Repository.
INFORMATICA REPOSITORY PASSWORD	Enter the password of the upgrade Informatica Repository.
INFORMATAICA FOLDER	Enter the value UPGRADE
INFORMATICA PORT	Enter the port number for the Repository Service. The default is 6001.

IBM DB2 Database Parameter Settings for the Upgrade Informatica Repository

Table E-7 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.
INFA DATABASE ALIAS	Enter the name of the database in which 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 for the upgrade Informatica Repository.
INFORMATICA SERVER ADDRESS	Enter the Informatica Server host address.
INFORMATICA FOLDER	Enter the value UPGRADE
INFORMATICA PORT	Enter the port number for the Repository Service. The default is 6001.

Teradata Database Parameter Settings for the Upgrade Informatica Repository

Table E-8 Teradata Database Parameter Settings for reset_infa_seq_gen.bat

Parameter	Setting
OLAP_SERVER	Enter the name of the Teradata 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 password of the data warehouse database.
INFORMATICA SERVER ADDRESS	Enter the Informatica Server host address.
INFORMATICA DB USERNAME	Enter the user ID of the upgrade Informatica Repository database.
INFORMATICA DB PASSWORD	Enter the password 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 for the upgrade Informatica Repository.
INFORMATICA FOLDER	Enter the value UPGRADE
INFORMATICA PORT	Enter the port number for the Repository Service. The default is 6001.