- Download and extract the product delivery file to find the data text file
- Download the text file US Field Value Key for US Address Fabric™ Data or CAN Field Value Key for Canada Address Fabric™ Data or EMEA Field Value Key for EMEA Address Fabric™ Data.
- Open the Field Value Key Create Table script in a text editor and confirm that the table name is set to field_value_key
- Run the Field Value Key Create Table script
- After the table structure has been created, copy the Oracle CTL template
into the directory containing the product delivery
file.
copy field_value_key from program 'cmd /c "type <path of data file>"' with (format csv ,delimiter ' ',header true)The following alternate syntax can be used if the data doesn't load using the command above:
Syntax:copy field_value_key from program 'cmd /c "type <path of data file>"' with (format csv ,delimiter e'\t',header true)<table_name>: Name of table created using Create Table script
<path_to_text_file>: Path to extracted data text file
<text_file_name.txt>: Extracted data text file name, including file extension
delimiter: Defines the text delimiter (in this case, delimiter is tab)
e'/t': Specifies alternate quoting for tab delimiter
Example:copy field_value_key from program 'cmd /c "type 'F:\field_value_key\ us_address_fabric_field_value_key.txt"' with (format csv ,delimiter ' ',header true)Alternate command:
copy us_address_fabric from program 'cmd /c "type 'F:\US_Address_Fabric\ us_address_fabric_field_value_key.txt"' with (format csv ,delimiter e'\t',header true)