Skip to Content
0
Former Member
Jun 08, 2009 at 10:01 AM

PK in Table Comparison - History Preserving

41 Views

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 :