not able to do autocorrect load to salesforce table in bods
my requirement is to load from an oracle table to salesforce table.
source is not delta enabled [means source cannot send delta records and it is upto the bods job to figure out the delta]
the data flow is simple: one to one mapping of source to target fields.
i wanted to try the auto-correct load option, but i am not able to figure out what to populate this field "external id column name"
1 : i tried leaving this "external id" field blank,
the job failed with error message that this field cant be left blank
2: i tried to populate "external id" = "ID" [this is key column in oracle table],
the execution failed saying that "ID" column not allowed for "external id"
3: next i tried to populate "external id" = "Id" [this is key column in salesforce target table],
the execution failed saying that "Id" column not allowed for "external id"
4: next i tried to give other random columns , but none of them was successful.
i have mentioned the dataflow layout below
[source -> query transform (direct mappings) -> salesforce target table ]
this was resolved by creating external id on the salesforce table,
and providing that column name in the sf-target table properties.