Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 07 Sep 2001 @ 09:26:15 GMT


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


Subj:   Re: Data in DWH --- Issues
 
From:   David Wellman

Hi Amer,

Most sites that I work with clean the data as part of the etl process. As part of moving the data from the source systems (in your case the oltp systems) into the dwh the data gets cleaned. This may be done using a tool or it may be done using standard sql - and often it's a combination of the two.

Where dirty data is recognised, a lot of sites will go back and clean the source systems - maybe changing the data entry screens/forms to correctly validate and format the data.

Ultimately it is down to the individual site or application etc etc to decide where this process is done, I don't think there is a 'correct' answer.


Cheers,

Dave



     
  <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