Loading data to base tables directly using Informatica

Third Party Software

Loading data to base tables directly using Informatica

Hi,
We are using Informatica to load data to Teradata. We use Loader
object and load data using Fastload and Multiload. In all our
loads we extract the data from MSSQL databases and load the data
to a staging area in Teradata environment. once the data is
loaded in the staging area we then use Teradata BTEQ scripts
(out side informatica) to load the data into the actual
production base tables. There are quite a few cases where we can
load data into production Base tables directly from MSSQL using
Informatica loader object (FASTLOAD, MULTILOAD)but we are afraid
if that would cause any issues (Locking the tables, and the only
way to get the table is to drop the table and recreate it). I'd
appreciate if some one is following this approach, and if they
ran into any issues.

Thanks in advance.
1 REPLY

Re: Loading data to base tables directly using Informatica

Hi
http://www.teradata.com/teradataForum/shwmessage.aspx?ForumID=10&MessageID=6872
check this link for details