Procedure - complete - Latest

GroundView: Complete US Demographic Estimates and Projections Data Suite Getting Started Guide
Product type
Data
Portfolio
Enrich
Product family
Enrich Demographics > Demographic Estimates and Projections
Product
GroundView Demographics > Complete
Version
Latest
ft:locale
en-US
Product name
GroundView: Complete
ft:title
GroundView: Complete US Demographic Estimates and Projections Data Suite Getting Started Guide
Copyright
2024
First publish date
2016
ft:lastEdition
2025-09-26
ft:lastPublication
2025-09-26T16:42:02.443000
L1_Product_Gateway
Enrich
L2_Product_Segment
Data
L3_Product_Brand
Precisely Demographics
L4_Investment_Segment
Precisely Demographics
L5_Product_Group
Demographic E&P
L6_Product_Name
E&P Demographics
Note: The following procedure uses Consumer Spend as an example in command syntax. All other GeoEnrichment Demographics datasets can be uploaded by following the same steps and substituting the appropriate dataset name.
  1. Download the product delivery file.
  2. Extract the delivery file and find the text data file.
  3. Create the table structure in the database using the product-specific Create Table script. Be sure to change the table name in the template to the dataset you are loading. If, for example, you are loading the Consumer Spend dataset, the table should be named consumer_spend.
  4. Once the table structure has been created, copy the Oracle CTL template to the directory in which the product delivery file is located.
  5. Open the CTL file in a text editor.
  6. Add the path to the extracted data file to the infile statement.
  7. Replace Oracle destination table name in the CTL file 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.
  8. Open a Windows command prompt and enter the following: 
    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:\Consumer_Spend\Consumer_Spend_Data\
oracle_expenditure_ctl_template.ctl'
log='D:\Consumer_Spend\Consumer_Spend\consumer_spend.log'
  9. Data will begin loading in the database.