Output to Teradata DB takes long time

General
New Member

Output to Teradata DB takes long time

Hi!

 

I have the OUTPUT block configured as 'update, insert if new' and looks it takes enormous amount of time to process the data... For example the set of 10k records coming from the up stream workflow needs 2 hours (!) to be output to a TD table counts only 40k records... (with 8k records being inserted and 2k updated at the end). The TD table has a primary key defined on 4 fields.

 

Where is the long processing time coming from ? Is there anything could be done to optimize it?

1 REPLY 1
Ambassador

Re: Output to Teradata DB takes long time

What is an "OUTPUT block", which client are you talking about?

 

Seems your tool submits single row queries instead of workking on set level.