0 votes
Can someone provide a high level overview of how DSS uploads data to Teradata? Is it just submitting a batch of inserts or using any Teradata utilities such as FastLoad or MultiLoad?

I need to move ~70M rows (about 8 CHAR columns of ~2-20 width and a couple INT columns) from SQL Server to Teradata where the bulk of my data resides to continue processing in-database but the upload to Teradata is rather slow.  For my dataset it took approximately 7 hours.

I'm looking for any suggestions on optimizing the process.  Thanks!

1 Answer

0 votes

When syncing a dataset from SQL server to Terada, DSS submits a series of batch inserts. As of the latest release today, it is not using the specific Teradata utilities you mention.

In the specific case of syncing between Teradata and HDFS, we do use the fast TDCH method: https://doc.dataiku.com/dss/latest/connecting/sql/teradata.html#fast-sync-using-tdch

To check if there can be any optimization, can you please add a screenshot to your question with the output dataset "Settings > Advanced" tab ?

Best regards,

1,080 questions
1,123 answers
10,870 users

┬ęDataiku 2012-2018 - Privacy Policy