Big Table Tab

Overview

The Big Table object is where you stage your data for import. You load your data into this object via a traditional data import tool. You will need to create fields in the Big Table for each column of data being imported. Each field can be reused for multiple sources—for example, you can create a FirstName__c field to hold the first name of candidates you import from ACT test scores, SAT scores, any purchased list, etc.

Big Table Fields

The following Big Table fields are already created for you and serve important process functions:

Field Description
Big Table The name or serial number of the Big Table record (table row); this is populated automatically by Salesforce when you load data.
Source The origin of the data in the record. You must populate this field with the name of the appropriate Data Source, described in the next section.
Status This field marks the status of the Big Table record. The possible values are:
New This is the default value for newly created records, and only records with this status are processed during an import.
Processed The record has been imported.
Errored There was an error trying to process the record.
Hold Records will be ignored by Import Rx and remain in the Big Table.
Processed-Duplicate The record has been imported. Import Rx found an existing record and updated the record.
New-Duplicate Import Rx identified a potential duplicate record and a manual review is required.
Error Message Shows any error that occurred when trying to import the record.
Contact The contact record that was created or updated by the import of the record, populated after a successful import.

More on Processed-Duplicate and New-Duplicate Status

Processed-Duplicate

  • Manual Import Page: When processing a record from the Import Page, if there are duplicate records in the system and the user selects the existing record from the duplicate update screen, this status will be set for the Big Table record. Also, if only one duplicate record is in the system and the Automatically Update Duplicates checkbox is checked on the data source, this status will be set.
  • Scheduled Job: If there is only one duplicate record found in the system and Automatically Update Duplicates is checked on the data source, this status will be set.

New-Duplicate

This status only occurs when Automatically Update Duplicates is unchecked on the Data Source Record.

Steps to import records in a New - Duplicate status:

  1. First, update the Status from New - Duplicate to New on Big Table.
  2. Next, go to the Import Data tab, select the Data Source for the records where you updated the status, and click the Import Data button.
  3. Finally, you will review the results on the Duplicate Review Screen and resolve each duplicate.