All Forums Database
ppad001 18 posts Joined 06/11
11 Feb 2016
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!

Fred 1096 posts Joined 08/04
12 Feb 2016

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.

You must sign in to leave a comment.