Using the Data Quality Accelerator for Crisis Response

Back Next

Updating the Reference Tables

You can copy data values directly into a reference table that you open in the Developer tool.

However, because the CPT and ICD-10 reference tables contain large quantities of sensitive data, Informatica recommends the following best practice:

Export the reference table from the Model repository to your local system.

Update the reference data in Microsoft Excel.

Import the reference table that you updated to the Crisis Solution Accelerator project.

The export operation writes an XML file and a compressed dictionary file to a location that you specify. The XML file represents the reference table repository object. The dictionary file is a text file that contains the reference data values.

You'll update the values in the dictionary file, and you'll import the XML file back into the repository. The XML import process identifies the dictionary file and writes the dictionary file contents to the corresponding reference database table.

Exporting a Reference Table from the Model Repository

In the Developer tool, connect to the Model repository that contains the accelerator.

Select

File > Export

Select

Informatica > Export Object Metadata File

Click

Select the Crisis Solution Accelerator project, and click

Select the reference table object to export.

You can find the ICD-10 and CPT reference tables at the following location:

Dictionaries/General.

Browse to the directory to which you'll export the reference table. Click Save
, and click Next
.

The wizard displays any dependent object for the metadata object.

Click

to accept the dependent objects.

Verify that the Export content
option is checked, and verify the export settings:

Verify a name and location for the file that will contain the reference data values. The Developer tool Service exports the reference data file to a zip file.

By default, the wizard exports the ZIP file and the XML metadata file to the same directory.

Verify that the code page is UTF-8.

Do not update the probabilistic model settings.

Click

Finish

Updating a Reference Data in Microsoft Excel

To update the dictionary data associated with a reference table, complete the following steps:

Extract the compressed dictionary file, and navigate to the dictionary file. The file has the following extension:

.dic

Do not move the dictionary file to another location.

Open the dictionary file in Microsoft Excel.

Open the ICD-10 file that you downloaded in another instance of Microsoft Excel.

Or, copy the data from the appropriate web page into another instance of Microsoft Excel.

Copy the data that you require from the CPT or ICD-10 worksheet to the dictionary file.

Take care to preserve the column structure of the dictionary file. The rules that read the reference data are configured to treat one of the columns as the valid or preferred version of the data.

Save the dictionary file. Do not change the file name or file type.

After you save the file, create a zip file from the directories that you extracted in step 1.

Take care to preserve the directory structure of the file that you exported.

Importing a Reference Table to the Model Repository

The steps to import a reference table are similar to the steps to import a repository project that the document described earlier.

To import a single reference table, complete the following steps:

In the Developer tool, select the Crisis Solution Accelerator repository project and select File > Import
.

In the

Import

pane, select

Informatica > Import Object Metadata File (Advanced)

Click

Browse to the reference table XML file.

Click

Open

, and click

In the

Source

pane, expand the directory structure and select the reference table object.

Clik

Automatch

to Target to associate the updated reference table object with the current object in the repository.

Expand the

Resolution

option, and select Replace object in target.

The

Resolution

options specify how the import operation handles any duplicate object that it encounters.

Click

. The Developer tool lists any dependent objects for the import file.

Add any dependent objects to the target project.

Click

In the

Content Import Settings

pane, verify that the Import Content option is checked.

Browse to the compressed file that contains the dictionary file that you updated, and select the file.

The import operation updates the dictionary file data in the database tables and refreshes the reference table object in the Model repository.

Click

Open

Verify that the code page is UTF-8, and click

Accept the default options on the

Import Summary

page.

Click

Finish

When the import is complete, refresh the Model repository connection.

Appendix 2: Updating CPT and ICD-10 Reference Tables

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Using the Data Quality Accelerator for Crisis Response

Using the Data Quality Accelerator for Crisis Response

Updating the Reference Tables

Updating the Reference Tables

Exporting a Reference Table from the Model Repository

Updating a Reference Data in Microsoft Excel

Importing a Reference Table to the Model Repository