|
|
Archives of the TeradataForum
Message Posted: Fri, 16 Jan 2004 @ 22:02:53 GMT
Subj: | | Re: Does Informatica +really+ force MultiLoad worktables into the target database? |
|
From: | | John Adams |
On Fri, 16 Jan 2004 16:12:33 -0500, McBride, Michael wrote:
| 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 | |
This sounds like a very promising approach. Do you see much overhead by loading through the views?
Thanks,
John A
| |