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).