BTEQ VS informtica load

Third Party Software

BTEQ VS informtica load

Does Loading data using BTEQ faster than loading through Informatica workflows?

Anyone?
1 REPLY
Enthusiast

Re: BTEQ VS informtica load

A well designed Informatica workflow should always load data faster than a BTEQ .IMPORT script. BTEQ was not really designed for loading external data - you may want to consider comparing the performance of an Informatica workflow designed to use Teradata's FastLoad utility vs. a FastLoad script.