Example 2 - Record Versioning

Precondition

Parent_ID Parent_IDEXT Parent_ATTR Child_ID Child_IDEXT Child_ATTR
A1 A1 Aattr1 B1 B1 Battr1
A2 A2 Aattr2 B2 B2 Battr2
A3 A3 Aattr3 B3 B3 Battr3

Test

Parent_ID Parent_IDEXT Parent_ATTR Child_ID Child_IDEXT Child_ATTR
A1 A1 Aattrx B1 B1 Battr1
A2 A2 Aattr2 B2 B2 Battrx
A3 A3 Aattrx B3 B3 Battrx

Expected Results

  • Direct Load Import: A new version of A1(V2), A3(V2), B2(V2), B3(V2) will be created. For A2(V1) and B1(V1), a new version will not be created, since data is not changed.
  • Database Loader: New versions will be created for all records. A1(V2), A2(V2), A3(V2), B1(V2), B2(V2), B3(V2).