8 Replies Latest reply: May 19, 2013 6:03 PM by Frank.Hampshire-Oracle RSS

    OPA Batch Processor: multiple fields as primary-key

    PierreReynders
      In the configuration file for the OPA Batch Processor you have to define the primary key for all the csv-input-files. In our situation the primary key of some tables is a combination of some fields. For example we have a table "household" and a table "person". In the table "person" the primary key is a combination of the householdnumber and the personnumber (which is a serial number within the household).

      When I try to use a combination of fields as primary-key a get an error regarding the amount of fields in the csv. Is it a point of principle that a primary-field only can contain 1 field?

      Cheers, Pierre