Input Formats

Records in a delimited or XML format.

This is a record in a delimited format.

StreamName<sep>Operation<sep>column_1..<sep>column_n
    

In ESPDLM (ESP delimited format), all columns must be present in the delimited form and the row must end with a line feed character. Operation is a single character, {i|u|d|s|p} for insert, update, delete, safe delete (delete only if the record exists), and upsert respectively.

This is a record in an XML format.

<StreamName [ESP_OPS="i|u|d|s|p"] [ESP_FLAGS="s"] 
  column_name="value" ... column_name="value" />
    

If ESP_OPS is not present, operation is taken as an upsert. There is no requirement on the number of columns present. Those that are missing are taken to have null values. If ESP_FLAGS is present, it can only have the value "s" indicating that the SHINE flag should be set for the record.