Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Workforce Analytics > Process of Configuring Workforce Operations for Oracle 11i >

Configuring Address Types for Workforce Profile

This task is a step in the Process of Configuring Workforce Operations for Oracle 11i.

There are three address fields in the Employee dimension table:

• Permanent address
• Mail address
• Work address

For each of these, we use only the primary ones. In addition, the following logic is used to determine the various types of addresses:

• Permanent: Address Type = 'H' (This is also the home address, in other words)
• Mail: Address Type = 'M'. If this is not available, use Permanent address (which can be the best alternate for mailing address).
• Work: Address Type = 'Default'. If this is not available, use Permanent address (which can be the best alternate for mailing address).

You can modify this logic if required. For example, if your system tracks work address with a special address type 'W', then you should be able to modify the existing logic. Or, if you do not want to assume that the mail address (M) is same as the home address (H), you may want to remove the null evaluation check there.

To configure Address Type

1. In PowerCenter Designer, open the SDE_ORA1158_Adapter folder.
2. In Mapplet Designer, open the mplt_SA_ORA_EmployeeDimension mapplet.
3. Locate the expression transformation Exp_SA_Employees_Validate and scroll down the ports to get to the variables "HOME_ADDRESS_ID_VAR", "MAIL_ADDRESS_ID_VAR" and "DEFAULT_ADDRESS_ID_VAR".

   For example, if you have a specific address type for work addresses, (for example 'W'), you would modify the expression for the variable port DEFAULT_ADDRESS_ID_VAR as follows:

   From: :LKP.Lkp_Address_Id(INP_PERSON_ID, INP_EFFECTIVE_END_DATE, 'Y', 'Default', INP_DATASOURCE_NUM_ID)

   To: :LKP.Lkp_Address_Id(INP_PERSON_ID, INP_EFFECTIVE_END_DATE, 'Y', 'W', INP_DATASOURCE_NUM_ID)

   The output Address ID values are the next three ports "PERM_ADDRESS_ID", "MAIL_ADDRESS_ID" and "WORK_ADDRESS_ID". If you do not want to assume that the mail address (M) is same as the home address (H) in the event of mail address not being available, then you would modify the logic in the outgoing port "MAIL_ADDRESS_ID" as follows:

   From: IIF(ISNULL(MAIL_ADDRESS_ID_VAR), HOME_ADDRESS_ID_VAR, MAIL_ADDRESS_ID_VAR)

   To: MAIL_ADDRESS_ID_VAR

4. Validate and save changes to the repository. If you are using the version controlling for the Informatica repository, you will have to check in your changes as well.