Generating Primary Keys and Defaults

When field is not mapped to anything:

Enter value (New York for example) into SQL function field and
following SQL would be executed while inserting the data.
Insert into Customers (Customer,,,,City)  
Values (CutomerValue,,,”New-York”)

When field is mapped:

Enter value (New York for example) into default field and 
this value will be used for  inserts if source field is null or empty.


To insert empty string enter ’’ into default field.

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • aetl/processing_data/writer/primary_keys.txt
  • Last modified: 24/06/2015 16:55
  • by admin