I have table A with history enabled, all columns SCD type 2 except the PK and a record is marked as deleted when deleted in the source (with a seperate record).
In the next data area / data warehouse (DSA) i want to create an incremental table B based on table A, but I do not want to have deleted records from A in table B.
When follwing the incremental rule wizzard the incremental selection rule can be set based on the incrementaltimestamp but deletes can not be handled because table A has no deletes (is thomstone =1).
How to solve this the easiest?
I can only think of taking along the Isthombstone field to table B and delete the records in a post script but this should be possible musch easier I would say.
Suggestions?
Best answer by Roy V
View original