Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. In the Manage Tab click on the New or Edit links Type to create a new lookup table or edit an existing lookup table

Image Added   


2. Enter the following data for the descriptive information of this lookup table:

  • Name: the

...

  • dictionary entry
  • Description:

...

  •  freeform text description

...

  • of the lookup table
  • To Item: is the name of the source field for the contents that are being mapped
  • Default Value (optional): is a default value for values that are not mapped in the Dictionary Lookup Values
  • Governance: associated Governance item (future use)
  • Tags (optional): any metadata tags for easy searching
  • Notes (optional): 

...

  • freeform text

...

  • for notes
Info

Origin Source Types are required for Origin Connections

Warning

Deleting an Origin Source Type will exclude automatically all associated Origin Connections

Image Removed

Import Data Tab

Origin Source Types are captured during the Schema Snapshot > Origin Connections > Get Connections Tab process.
They are used to identify the type of the Origin Connections (e.g. folder, ODBC, OLEDB).

There are no IPDF default values.3. Click Image Addedto apply the changes.


Image Added

Import Data Tab

Use this feature to import lookup values from a MS Excel workbook.

Image Added

Step-by-step guide

  1. In the Manage Tab click on the New or Edit links
  2. Type the following data:
    1. Name: the name of the Origin Source Type
    2. Description: free text description
    3. Governance (optional): associated Governance item
    4. Notes (optional):  free text optional notes
Info

Origin Source Types are required for Origin Connections

Warning

Deleting an Origin Source Type will exclude automatically all associated Origin Connections

...

  1. Click on the template link
  2. open the MS Excel workbook and find two sheets
    1. Sheet named "Lookup" has the same fields as described in the definition screen above - you can import multiple entries into the dictionary
    2. Sheet named "LookupValues" has the same fields described in Dictionary Lookup Values in this help document
  3. Make any entries and save the MS Excel workbook
  4. From the Import Data Tab, browse for the file you updated and upload it
  5. The processing messages is followed by a success message

Image Added

Image Added

Linked Dictionary Entries Tab

...