problem using Informatica to load Teradata tables.

Analytics

problem using Informatica to load Teradata tables.

I have an issue while loading data from sql server to Teradata database. It takes a very long time to load 100K rows. when i checked the log I guess it is doing a row level insert instead of a bulk load. Here is a part of the session log
MASTER> PETL_24006 Starting data movement.
MAPPING> TM_6660 Total Buffer Pool size is 12000000 bytes and Block size is 64000 bytes.
READER_1_1_1> DBG_21438 Reader: Source is [SA3ADLSQL02], user [ABCDEF]
READER_1_1_1> BLKR_16003 Initialization completed successfully.
WRITER_1_*_1> WRT_8148 Writer: Target is database [JQU], user [ABCDEF], bulk mode [N/A]
WRITER_1_*_1> CMN_1021 Database driver event...
CMN_1021 [Teradata Event Using array fetches. Teradata Event Using Single Row Inserts. connect string = [Siebel_Warehouse_Dev]. userid = [ABCDEF]]
WRITER_1_*_1> WRT_8124 Target Table JQU_ProspectOwnerTracker :SQL INSERT statement:

Now how can i set the option to do a BULK LOAD.? I remember there is a place to do that but I cant find it. I'd appreciate your help.

Thanks.

1 REPLY
N/A

Re: problem using Informatica to load Teradata tables.

I don't work with Informatica anymore, but if I remember correclty, you have to choose the correct loader.

For TD, there are four: Relational, Fastload, MLoad, and TPump.