|
|
|
Supreme Being
Group: Forum Members
Last Login: 10/7/2008 12:54:51 PM
Posts: 116,
Visits: 20
|
|
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.
Feroz Shaik
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 10/7/2008 12:54:51 PM
Posts: 116,
Visits: 20
|
|
Hi
http://www.teradata.com/teradataForum/shwmessage.aspx?ForumID=10&MessageID=6872
check this link for details
Feroz Shaik
|
|
|
|