Optimal Process to load data from SQLserver to Teradata

Database
Enthusiast

Optimal Process to load data from SQLserver to Teradata

We have a a number of processes where in we transfer the data from SQL server to TD. We extract he data as files & then dump it using Fastload. Just wanted to know is there any other process we can experiment to make this load any more faster ? The record number is a bit high so takes around significant time.

Hope I made myself clear.

Thanks!

Tags (2)
1 REPLY
Teradata Employee

Re: Optimal Process to load data from SQLserver to Teradata

Where is the time being spent? If much of the time is writing / reading the file extract, then consider using Teradata Parallel Transporter, SSIS, or some third-party tool to "pipe" data directly between databases and eliminate the intermediate file.