 |
 |
Archives of the TeradataForum
Message Posted: Mon, 14 Apr 2003 @ 20:45:01 GMT
| Subj: | | Re: Loading Back Dated Data |
| |
| From: | | Crisafulli, Ronald |
I guess it would depend on where the transaction surfaced. At one of the retailers I did some work for Back Posting was not uncommon.
However, if the transaction was discovered at the day/item/shop level being their lowest level then it was input and rolled up to the higher
level tables and all the aggregates were re-calculated again. On the other hand it could also have been submitted as a store adjustment if
that was what the business wanted to do. If an entire week was missing or miss calculated I have actually gone in and deleted the week or
the date range and then re submitted the transactions and processed then for re-aggregation and rollup. This can get tricky, but it can be
done. You almost have to process them independently and then merge each set into it's own table or group after the processing is over.
God Luck
Ron..
Ron Crisafulli
Database Administrator
Lerner New York and Company
| |
