johnherman
MIS
I'm running a database, actually a data warehouse, downstream from a production OLTP system written and managed by a separate group in the company. The OLTP provides a daily "delta" file of inserts, updates, and deletes which is used to update the downstream system(s).
However, on occasion, the OLTP system will send a script which they have run on their system, referred to by them as a datafix, which they expect us to run on the downstream system. These datafixes vary, sometimes changing the status of a record from Open to Closed or vice versa. Sometimes they are used to populate columns which have been added during a software upgrade to the OLTP. Most recently, I received a script wanting to delete a row.
I have alway had a "bad feeling" about these fixes, and have saved them off in an archive for audit trail purposes. However, requesting a physical delete is something which really sent up a red flag for me.
I'm looking for references and reasons to publish in a memo requesting that this process of updating be stopped and normal update channels (ETL via the Delta tables) be used exclusively. Thanks in advance for your help.
-------------------------
The reasonable man adapts himself to the world. The unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. - George Bernard Shaw
However, on occasion, the OLTP system will send a script which they have run on their system, referred to by them as a datafix, which they expect us to run on the downstream system. These datafixes vary, sometimes changing the status of a record from Open to Closed or vice versa. Sometimes they are used to populate columns which have been added during a software upgrade to the OLTP. Most recently, I received a script wanting to delete a row.
I have alway had a "bad feeling" about these fixes, and have saved them off in an archive for audit trail purposes. However, requesting a physical delete is something which really sent up a red flag for me.
I'm looking for references and reasons to publish in a memo requesting that this process of updating be stopped and normal update channels (ETL via the Delta tables) be used exclusively. Thanks in advance for your help.
-------------------------
The reasonable man adapts himself to the world. The unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. - George Bernard Shaw
