4 Data Portability

This section provides information about the Data Portability feature used in the OFSAA Data Foundation applications.

Topics:

Overview of Data Portability in OFSAA

According to the Data Protection guidelines, a scenario may occur with a customer in which a Data Subject requests the financial institution to share the PII of that Data Subject stored in the application. To cater to such a scenario, the customer may use T2F (Table to File) functionality provided by AAI. This T2F functionality enables the customer to query the data warehouse and save the attributes to a file.

Data Portability Scenario

This is a sample scenario to apply Data Portability:

1. The DIM_PARTY table consists of a set of PIIs for multiple Data Subjects.

Figure 4: Sample of the DIM_PARTY table

This illustration shows the DIM_PARTY table sample consisting of a set of Personal Identifiable Information.

A Data Subject requests the financial institution to share a copy of the PII data of that Data Subject stored by the financial institution. For illustration, the Data Subject with V_PAN_CARD_ID EMHPL5167K is used.

2. To make a file copy of the PII requested by the Data Subject, the User (financial institution) must perform T2F data mapping. Follow the Data Mapping procedure in the Defining Data Mapping to File (T2F, H2F) section in the required 8.1.x.x.x release version of the Oracle Financial Services Advanced Analytical Applications Infrastructure User Guide to perform the following steps:

a. Create a T2F definition for the scenario mentioned in the preceding step. Map the column V_PAN_CARD_ID to V_PARTY_ID in the DIM_PARTY table.

Figure 5: Map the columns selected for the T2F definition creation in the Entity Selection page

This illustration shows mapping the columns selected for the T2F definition creation in the Entity Selection page.

b. Create a Batch to run the T2F.

Figure 6: Create a batch to Run the T2F

This illustration shows creating a batch to Run the T2F.

c. Create a Task in the Batch.

Figure 7: Create a task in the T2F batch

This illustration shows creating a task in the T2F batch.

d. Execute the Batch. Verify the progress of batch execution in the Batch Monitor page.

Figure 8: Execute the T2F batch

This illustration shows executing the T2F batch.

3. The output file path is as follows:

/scratch/ofsaaapp1/ftpshare/FSDFINFO/dmt/def/<T2F_name>/<Batch_name>/<batch_run_id>/<information_date>/<T2Fname>.dat

For example:

/scratch/ofsaaapp1/ftpshare/FSDFINFO/dmt/def/T2F_DIM_PARTY/FSDFINFO_T2F_DIM_PARTY_20180504_1_Task1/20180504/T2F_DIM_PARTY.dat

NOTE:

This extracted file consists of PII of a Data Subject that must be encrypted. See the Data Mapping section in the Data Management Tools section in the required 8.1.x.x.x release version of the Oracle Financial Services Advanced Analytical Applications Infrastructure User Guide.

4. This is a sample T2F output file with the PII details requested by the Data Subject.

Figure 9: A sample of the T2F output file

This illustration shows the T2F output file sample.