Loading Field Value Key Data - address_fabric_1 - Latest

Address Fabric™ Data Getting Started Guide
Product type
Data
Portfolio
Enrich
Product family
Enrich Addresses > World Addresses
Product
Address Fabric™ Data > Address Fabric™ Data
Version
Latest
Language
English
Product name
Address Fabric™
Title
Address Fabric™ Data Getting Started Guide
Copyright
2024
First publish date
2016
Last updated
2024-10-30
Published on
2024-10-30T05:31:19.561000
  1. Download and extract the product delivery file to find the data text file
  2. Download the text file US Field Value Key for US Address Fabric™ Data or CAN Field Value Key for Canada Address Fabric™ Data
  3. Open the Field Value Key Create Table script in a text editor and confirm that the table name is set to field_value_key
  4. Run the Field Value Key Create Table script
  5. After the table structure has been created, copy the Oracle CTL template into the directory containing the product delivery file.
  6. Open the CTL file in a text editor
  7. Add the path to the extracted data text file to the infile statement
  8. Replace Oracle destination table name with field_value_key
  9. Save changes
  10. Load data by issuing the following command from a Windows command prompt:
    sqlldr userid=<username>/<password>@<database_connection>
control=<path>/<ctl_file_name> log=<path>/<log_file_name>
    Example:
    sqlldr userid=username/password@hostname/service control='D:\us_address_fabric\
oracle_field_value_key_ctl_template.ctl' skip=1
log='D:\us_address_fabric\oracle_field_value_key_template.log'
Note: The TRAILING NULLCOLS clause used in the CTL file instructs SQL Loader to treat any relatively positioned columns that are not present in the record as null columns.