Archives of the TeradataForum
Message Posted: Wed, 03 Mar 2010 @ 08:14:31 GMT
Is there a feasible way of calculating a checksum for an entire (small) table in Teradata SQL? And therefore also to do this for a set of tables.
I have a client app in Excel/VBA using a Teradata as a source for analysing mass data but also for holding a number of small control tables just for the app. Typically these small tables get used to populate pull down menus in the client interface. There's about 20 of them.
There is no other available source that can be shared by all client users.
My problem is that the time to load all of these tables is problematic when the Teradata is under heavy load.
I do have the ability to let each client store a local copy of the small tables but to manage that I need a simple way to know when to refresh these from the Teradata sources.
What I want to be able to do is have some Teradata SQL that can let the client app detect which control tables have changed (rows) so it can selectively rebuild its local store.
I can imagine a complex process by which I as admin could manage a control table that holds a list of update numbers per table which the client simply checks against. What I'd prefer is something that isn't dependent on my continual diligence.
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023