 |
 |
Archives of the TeradataForum
Message Posted: Fri, 16 Jan 2004 @ 21:12:33 GMT
| 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
| |
