Hi,
I am trying to insert/update rows in a table. We have to maintain history , type 2 SCD. Whats the best way of implementing it. When ever I lookup against the table for update or inserts what is the best practise and how do i get the max timestamp row for a matching key when ever there is a update.
Thanks!!!!!!!!
Mack
Insert Update on Max Timestamp
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Best practice is to pre-load a lookup source (for example a hashed file) with the current values and to maintain this during the load process.
Search the forum for "Type 2", "lock for update" and "slowly changing dimension" for techniques.
Search the forum for "Type 2", "lock for update" and "slowly changing dimension" for techniques.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.