Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Updating a database

Updating a database

Updating a database

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close