A Configuring Informatica Parameter Files

This appendix contains instructions for configuring the Informatica parameter files. It contains the following topics:

• Section A.1, "Setting Parameters in 793_UPG_PARAMS.txt"

• Section A.2, "Setting Parameters in 794_UPG_PARAMS.txt"

• Section A.3, "Setting Parameters in 795_UPG_PARAMS.txt"

• Section A.4, "Setting Parameters in 7951_UPG_PARAMS.txt"

• Section A.5, "Setting Parameters in 796_UPG_PARAMS.txt for All Source Systems"

• Section A.6, "Setting Additional Parameters in 796_UPG_PARAMS.txt for Oracle EBS 11i Source Systems"

• Section A.7, "Setting Additional Parameters in 796_UPG_PARAMS.txt for Siebel Source Systems"

• Section A.8, "Setting Parameters in 7961_UPG_PARAMS.txt"

• Section A.9, "Setting Parameters in 7962_UPG_PARAMS.txt"

• Section A.10, "Setting Additional Parameters in 7962_UPG_PARAMS.txt for PeopleSoft Source Systems"

A.1 Setting Parameters in 793_UPG_PARAMS.txt

Follow this procedure to configure the 793_UPG_PARAMS.txt file.

To configure the 793_UPG_PARAMS.txt file

1. Navigate to the folder OracleBI\dwrep\Upgrade\Informatica\ParameterFiles and copy the file 793_UPG_PARAMS.txt into the SrcFiles folder on the Informatica Server machine, for example, <PowerCenter_installation_Directory>\server\infa_shared\SrcFiles.

2. Set the parameter $$ETL_PROC_WID to the latest ETL_PROC_WID value from the database. You can get this value from W_PARAM_G.ETL_PROC_WID.

3. Set the parameter $$DATASOURCE_NUM_ID to the relevant value from the source system setup.

4. Search for parameter values defined with the "TO_DATE" function. Edit the function to use the appropriate function for data conversion based on the database type:

   - For Oracle databases, use "TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"

   - For SQL Server databases, use "CONVERT(datetime,'1899-01-01')"

   - For DB2 databases, use "TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"

   - For Teradata databases, use "cast('1899-01-01' as timestamp format 'YYYY-MM-DD')"

A.2 Setting Parameters in 794_UPG_PARAMS.txt

Follow this procedure to configure the 794_UPG_PARAMS.txt file.

To configure the 794_UPG_PARAMS.txt file

1. Navigate to the folder OracleBI\dwrep\Upgrade\Informatica\ParameterFiles and copy the file 794_UPG_PARAMS.txt into the SrcFiles folder on the Informatica Server machine, for example, <PowerCenter_installation_Directory>\server\infa_shared\SrcFiles.

2. Set the parameter $$ETL_PROC_WID to the latest ETL_PROC_WID value from the database. You can get this value from W_PARAM_G.ETL_PROC_WID.

3. Set the parameter $$DATASOURCE_NUM_ID to the relevant value from the source system setup.

4. Search for parameter values defined with the "TO_DATE" function. Edit the function to use the appropriate function for data conversion based on the database type:

   - For Oracle databases, use "TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"

   - For SQL Server databases, use "CONVERT(datetime,'1899-01-01')"

   - For DB2 databases, use "TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"

   - For Teradata databases, use "cast('1899-01-01' as timestamp format 'YYYY-MM-DD')"

A.3 Setting Parameters in 795_UPG_PARAMS.txt

Follow this procedure to configure the 795_UPG_PARAMS.txt file.

To configure the 795_UPG_PARAMS.txt file

1. Navigate to the folder OracleBI\dwrep\Upgrade\Informatica\ParameterFiles and copy the file 795_UPG_PARAMS.txt into the SrcFiles folder on the Informatica Server machine, for example, <PowerCenter_installation_Directory>\server\infa_shared\SrcFiles.

2. Set the parameter $$ETL_PROC_WID to the latest ETL_PROC_WID value from the database. You can get this value from W_PARAM_G.ETL_PROC_WID.

3. Set the parameter $$DATASOURCE_NUM_ID to the relevant value from the source system setup.

4. Search for parameter values defined with the "TO_DATE" function. Edit the function to use the appropriate function for data conversion based on the database type:

   - For Oracle databases, use "TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"

   - For SQL Server databases, use "CONVERT(datetime,'1899-01-01')"

   - For DB2 databases, use "TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"

   - For Teradata databases, use "cast('1899-01-01' as timestamp format 'YYYY-MM-DD')"

A.4 Setting Parameters in 7951_UPG_PARAMS.txt

Follow this procedure to configure the 7951_UPG_PARAMS.txt file.

To configure the 7951_UPG_PARAMS.txt file

1. Navigate to the folder OracleBI\dwrep\Upgrade\Informatica\ParameterFiles and copy the file 7951_UPG_PARAMS.txt into the SrcFiles folder on the Informatica Server machine, for example, <PowerCenter_installation_Directory>\server\infa_shared\SrcFiles.

2. Set the parameter $$ETL_PROC_WID to the latest ETL_PROC_WID value from the database. You can get this value from W_PARAM_G.ETL_PROC_WID.

3. Set the parameter $$DATASOURCE_NUM_ID to the relevant value from the source system setup.

4. Search for parameter values defined with the "TO_DATE" function. Edit the function to use the appropriate function for data conversion based on the database type:

   - For Oracle databases, use "TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"

   - For SQL Server databases, use "CONVERT(datetime,'1899-01-01')"

   - For DB2 databases, use "TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"

   - For Teradata databases, use "cast('1899-01-01' as timestamp format 'YYYY-MM-DD')"

A.5 Setting Parameters in 796_UPG_PARAMS.txt for All Source Systems

Follow this procedure to configure the 796_UPG_PARAMS.txt file. This procedure is required for all source systems.

To configure the 796_UPG_PARAMS.txt file

1. Navigate to the folder OracleBI\dwrep\Upgrade\Informatica\ParameterFiles and copy the file 796_UPG_PARAMS.txt into the SrcFiles folder on the Informatica Server machine, for example, <PowerCenter_installation_Directory>\server\infa_shared\SrcFiles.

2. In the 796_UPG_PARAMS.txt file, set the following parameters:

   1. $$ETL_PROC_WID. Set this parameter to the relevant value from the source system setup. You can get this value from W_PARAM_G.ETL_PROC_WID

   2. $$DATASOURCE_NUM_ID. Set this parameter to the relevant value from the source system setup.

   3. $$INITIAL_EXTRACT_DATE. Set this parameter to the initial extraction data of the data warehouse.

   4. $$WH_DATASOURCE_NUM_ID. Set this parameter to the data source number ID you have set up for the data warehouse.

   5. $$START_DATE. Get this value from the Source System Parameters tab in DAC.

   6. $$END_DATE. Get this value from the Source System Parameters tab in DAC.

   7. $$MASTER_ORG. Get this value from the Source System Parameters tab in DAC.

   8. $$INV_PROD_CAT_SET_ID1. Get this value from the Source System Parameters tab in DAC.

   9. $$PROD_CAT_SET_ID1. Get this value from the Source System Parameters tab in DAC.

   10. Set the parameter $$IS_SOURCE_PRE_80 to Y if your source OLTP application was on a version prior to Siebel 8.0 before you began the upgrade process. Otherwise, set this parameter to N.

   11. Search for parameter values defined with the "TO_DATE" function. Edit the function to use the appropriate function for data conversion based on the database type:

       - For Oracle databases, use "TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"

       - For SQL Server databases, use "CONVERT(datetime,'1899-01-01')"

       - For DB2 databases, use "TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"

       - For Teradata databases, use "cast('1899-01-01' as timestamp format 'YYYY-MM-DD')"

A.6 Setting Additional Parameters in 796_UPG_PARAMS.txt for Oracle EBS 11i Source Systems

This procedure is only applicable to Oracle EBS 11i source systems.

To configure parameters for Oracle EBS 11i source systems

1. Navigate to the SrcFiles folder on the Informatica Server machine, for example, C:\Program Files\Informatica PowerCenter 8.6.1\server\infa_shared\SrcFiles.

2. Open the file 796_UPG_PARAMS.txt.

3. Note the values for the following parameters:

   • $$ORA_DATASOURCE_NUM_ID_LIST

   • $$GRAIN

   • $$GBL_DATASOURCE_NUM_ID

   • $$QUALIFICATION_CATEGORY_LIST

4. In DAC, go the Design view, and select the appropriate custom container.

5. Select the Source System Parameters tab.

6. Query for the parameters listed in Step 3, and compare the values.

7. If necessary, change the values for the parameters in the 796_UPG_PARAMS.txt file to match the values for the parameters in the DAC Source System Parameters tab.

8. Save the 796_UPG_PARAMS.txt file.

A.7 Setting Additional Parameters in 796_UPG_PARAMS.txt for Siebel Source Systems

This procedure is only applicable to Siebel source systems.

To configure parameters for Siebel source systems

1. Navigate to the SrcFiles folder on the Informatica Server machine, for example, C:\Program Files\Informatica PowerCenter 8.6.1\server\infa_shared\SrcFiles.

2. Open the file 796_UPG_PARAMS.txt.

3. Note the values for the following parameters:

   • $$HI_DT

   • $$LOW_DT

   • $$NAME_ORDER_WITH_FIRSTNAME

4. In DAC, go the Design view, and select the appropriate custom container.

5. Select the Source System Parameters tab.

6. Query for the parameters listed in Step 3, and compare the values.

7. If necessary, change the values for the parameters in the 796_UPG_PARAMS.txt file to match the values for the parameters in the DAC Source System Parameters tab.

8. Save the 796_UPG_PARAMS.txt file.

A.8 Setting Parameters in 7961_UPG_PARAMS.txt

Follow this procedure to configure the 7961_UPG_PARAMS.txt file.

To configure the 7961_UPG_PARAMS.txt file

1. Navigate to the folder OracleBI\dwrep\Upgrade\Informatica\ParameterFiles and copy the file 7961_UPG_PARAMS.txt into the SrcFiles folder on the Informatica Server machine, for example, <PowerCenter_installation_Directory>\server\infa_shared\SrcFiles.

2. In the 7961_UPG_PARAMS.txt file, set the following parameters:

   1. $$ETL_PROC_WID. Set this parameter to the relevant value from the source system setup. You can get this value from W_PARAM_G.ETL_PROC_WID

   2. $$DATASOURCE_NUM_ID. Set this parameter to the relevant value from the source system setup.

   3. $$INITIAL_EXTRACT_DATE. Set this parameter to the initial extraction data of the data warehouse.

   4. $$WH_DATASOURCE_NUM_ID. Set this parameter to the data source number ID you have set up for the data warehouse.

   5. Search for parameter values defined with the "TO_DATE" function. Edit the function to use the appropriate function for data conversion based on the database type:

      - For Oracle databases, use "TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"

      - For SQL Server databases, use "CONVERT(datetime,'1899-01-01')"

      - For DB2 databases, use "TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"

      - For Teradata databases, use "cast('1899-01-01' as timestamp format 'YYYY-MM-DD')"

A.9 Setting Parameters in 7962_UPG_PARAMS.txt

Follow this procedure to configure the 7962_UPG_PARAMS.txt file.

Note: If your source system is PeopleSoft, you must also configure the parameters in Appendix A, "Setting Additional Parameters in 7962_UPG_PARAMS.txt for PeopleSoft Source Systems."

To configure the 7962_UPG_PARAMS.txt file

1. Navigate to the folder OracleBI\dwrep\Upgrade\Informatica\ParameterFiles and copy the file 7962_UPG_PARAMS.txt into the SrcFiles folder on the Informatica Server machine, for example, <PowerCenter_installation_Directory>\server\infa_shared\SrcFiles.

2. In the 7962_UPG_PARAMS.txt file, set the following parameters:

   1. $$ETL_PROC_WID. Set this parameter to the relevant value from the source system setup. You can get this value from W_PARAM_G.ETL_PROC_WID

   2. $$DATASOURCE_NUM_ID. Set this parameter to the relevant value from the source system setup.

   3. $$INITIAL_EXTRACT_DATE. Set this parameter to the initial extraction data of the data warehouse.

   4. $$WH_DATASOURCE_NUM_ID. Set this parameter to the data source number ID you have set up for the data warehouse.

   5. Search for parameter values defined with the "TO_DATE" function. Edit the function to use the appropriate function for data conversion based on the database type:

      - For Oracle databases, use "TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"

      - For SQL Server databases, use "CONVERT(datetime,'1899-01-01')"

      - For DB2 databases, use "TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"

      - For Teradata databases, use "cast('1899-01-01' as timestamp format 'YYYY-MM-DD')"

A.10 Setting Additional Parameters in 7962_UPG_PARAMS.txt for PeopleSoft Source Systems

If your source system is PeopleSoft, you must follow the instructions in this section after completing the instructions in Appendix A, "Setting Parameters in 7962_UPG_PARAMS.txt."

To configure the 7962_UPG_PARAMS.txt file

1. Open the 7962_UPG_PARAMS.txt file.

   Note: Make sure you perform the procedure in Section A.9, "Setting Parameters in 7962_UPG_PARAMS.txt," before you begin this procedure.

2. If you are using PeopleSoft version 8.9 or higher, configure the following parameters in the 7962_UPG_PARAMS.txt file specific to multiple product category enhancement:

   1. For the $$TREE_NAME1 parameter, set the value to a tree name for which you want to include the product categories. Generally, this value is ALL_PURCHASE_ITEMS. You can use the following SQL to obtain the TREE_NAMES:

      SELECT * FROM PSTREEDEFN WHERE TREE_STRCT_ID = 'ITEMS'
      

   2. The TREE_STRUCT in the PeopleSoft Tree that defines the Item Category Tree generally has the value ITEMS. If you changed this value, you must update the parameter $$TREE_STRUCT_ID_LIST with the appropriate value.

3. Verify the value for the PSFT_OLTP_VER parameter matches the version of PeopleSoft you are using.

   PeopleSoft Version	Enter Parameter Value
   PeopleSoft version 8.9	PSFT_OLTP_VER=90
   PeopleSoft version 9.0	PSFT_OLTP_VER=90
   PeopleSoft version 9.1	PSFT_OLTP_VER=91

   
   

   The default value for this parameter is PSFT_OLTP_VER=91.

   Caution:

   You must enter the correct value for this parameter or else the upgrade process will fail.