Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 16 Jan 2004 @ 21:12:33 GMT


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


Subj:   Re: Does Informatica +really+ force MultiLoad worktables into the target database?
 
From:   McBride, Michael

We use Informatica for our ETL process, but we do not let any application, including Informatica tools, touch the base tables (in the production database). Access is granted through a separate, staging database that contains base views (views that are one-to-one images of the base tables by the same name as the tables. The staging database has the access rights to the production database, thereby making it simple and straightforward for security / access profile maintenance. Thus, when Informatica mloads data into the staging view, the work/temp tables are allocated in the staging database, not the target table database, providing the proper separation and control of production data space versus the load application data space...


Michael E. McBride
Teradata Certified Master
Teradata Database Administrator
Data Architect and Data Warehouse Practitioner
American Eagle Outfitters



     
  <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