Hello,
I've some problems trying to implement a tabel with valid-from and valid-to dates.
The primary key of my table has 3 fields : A , B and Valid-to.
no surrogate key.
In TC I've met :
- as Input Primary Key Colums : A, B and Valid-to
- as compare columns : the other columns
works with sorted input, sorted in the same order as the fields in PK.
In History Preserving :
- valid_from = field Valid-from
- valid _to = field Valid-to
- Valid to date value = 9999.12.31
- Old record : use valid from of new record.
No current flag.
Compare columns : same as in TC.
Problem :