Oracle® Business Intelligence Applications Upgrade Guide for Informatica PowerCenter Users Version 7.9.6 Part Number E14218-01 |
|
|
View PDF |
This appendix contains the following topic:
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. |