Loading Property Attributes Assessment data - property_attributes_assessment - Latest

Property Attributes Assessment Getting Started Guide
Product type
Data
Portfolio
Enrich
Product family
Enrich Properties > Property Features
Product
Property Attributes Assessment
Version
Latest
ft:locale
en-US
Product name
Property Attributes Assessment
ft:title
Property Attributes Assessment Getting Started Guide
Copyright
2025
First publish date
2020
ft:lastEdition
2025-12-24
ft:lastPublication
2025-12-24T08:35:24.668000
  1. Download the product delivery file.
  2. Extract the delivery file to find the data text file.
  3. Open the Property Attributes Assessment Data Create Table script in a text editor and confirm that the table name is set to asmt.
  4. Run the 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 asmt.
  9. Save changes.

  10. Copy the following command to:

    1. Load the sample and state datafiles:

      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_Attributes_Assessment\
Property_Attributes_Assessment_Data\oracle_asmt_ctl_template.ctl' log='D:\Property_Attributes_Assessment\
Property_Attributes_Assessment\asmt.log'
    2. Load nationwide datafiles (to skip first record as it is header/column record): 
      sqlldr userid=<username>/<password>@<database_connection>
control=<path>/<ctl_file_name> skip=1 log=<path>/<log_file_name>
      Example:
      sqlldr userid=username/password@hostname/service control = 'D:\Property_Attributes_Assessment\
Property_Attributes_Assessment_Data\oracle_asmt.ctl' skip=1 log='D:\
Property_Attributes_Assessment\Property_Attributes_Assessment_Data\asmt.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.