Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 14 Apr 2003 @ 20:45:01 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016