Archives of the TeradataForum
Message Posted: Fri, 17 Jan 2003 @ 16:31:05 GMT
We get updates for account table everyday. Using this we need to maintain an account_class history table which has the foll. structure.
Which is the best possible way (performance wise) to update the account_class history table. The incoming record doesn't hold the prior_accnt_class or anything that explicity states that the acct_class has changed and hence we need a lookup for this.
Any help is greatly appreciated.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|