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.