For those of you that have account records that have parent records that change due to mergers, acquisitions, etc, how are you handling the previous history of the quote, order, job, etc data that was from the previous parent for audit purposes. Other than creating new records each time or taking a time based snapshot of the database to be stored in a CUBE, what other methods are any of you using out there to maintain this data? See detail of what I mean below:
Parent account 1234 owns Child account 5678, Child Account 5678 is bought by new Parent account 2345. All transactional activity that was tied to the child account while owned by Parent 1234, needs to not be seen as history tied to the new parent 2345. If we wanted to look back at history over the last 2-3 years of parent-Child transactional data, when the chikld may have been bought and sold several times, we are looking to find a way to maintain an accurate history of point in time. Other than snapshot to CUBE, how can this be handled?
Any thoughts?
Christopher W. Marsch
IT/Database Administrator
Mechanical Dynamics & Analysis, Ltd.
19E British American Blvd.
Latham, NY 12110
(518) 399-3616 x272
Cell: (518) 795-0200
[Non-text portions of this message have been removed]
Parent account 1234 owns Child account 5678, Child Account 5678 is bought by new Parent account 2345. All transactional activity that was tied to the child account while owned by Parent 1234, needs to not be seen as history tied to the new parent 2345. If we wanted to look back at history over the last 2-3 years of parent-Child transactional data, when the chikld may have been bought and sold several times, we are looking to find a way to maintain an accurate history of point in time. Other than snapshot to CUBE, how can this be handled?
Any thoughts?
Christopher W. Marsch
IT/Database Administrator
Mechanical Dynamics & Analysis, Ltd.
19E British American Blvd.
Latham, NY 12110
(518) 399-3616 x272
Cell: (518) 795-0200
[Non-text portions of this message have been removed]