Loading Property Historical Sales Field Value Key Data - property_historical_sales - Latest

Property Historical Sales Getting Started Guide
Product type
Data
Portfolio
Enrich
Product family
Enrich Properties > Property Features
Product
Property Historical Sales
Version
Latest
ft:locale
en-US
Product name
Property Historical Sales
ft:title
Property Historical Sales Getting Started Guide
Copyright
2023
First publish date
2020
ft:lastEdition
2025-09-29
ft:lastPublication
2025-09-29T14:56:42.605000
  1. Download the Field Value Key data file.

  2. Create the table structure in the database using the Create Table script. Be sure to change the table name in the template to hist_field_value_key.

  3. Once the table structure has been created, copy the Oracle CTL template to the directory in which the product delivery file is located.

  4. Open the CTL file in a text editor. Add the path to the data text file to the infile statement and replace Oracle destination table name with the name of the table created in Step 3.
    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
  5. 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:\Property_Historical_Sales\Property_Historical_Sales_Data\
oracle_hist_field_value_key.ctl' skip=1
log=D:\Property_Historical_Sales\
Property_Historical_Sales_Data\oracle_hist_field_value_key_template.log'
  6. Data will begin loading into the database.