Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 18 Jun 2002 @ 14:54:18 GMT


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


Subj:   Re: Testing Methodology
 
From:   Alan Paluszek

Ganesh:

I used a similar approach of only using Informatica to apply the transformation business rules to source data at two different client accounts. This provided the client with Metadata and the MX2 bridge to disseminate the Metadata to reporting tools.

In both cases, we opted to load Teradata staging tables with FastLoad. We applied the data in the staging tables to the core data warehouse database using SQL in BTEQ scripts. We found that the more data work that we did on the Teradata database, the shorter the batch cycle times.

Hope this helps.


Regards,

Al Paluszek
APP Consulting, Inc



     
  <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: 15 Jun 2023