topic Creating Volatile Tables Within Talend Job in Talend Studio

Creating Volatile Tables Within Talend Job

Anonymous — Tue, 26 Jun 2018 16:17:25 GMT

In my ETL job, I am doing much of the processing in the Teradata environment, i.e., creating volatile tables. Is there an option within Talend that will allow me to do this? These volatile tables will be used for other tables to join to. I know there is a tTeradataInput, but these volatile tables will need to be created before that. Any help would be appreciated!

Re: Creating Volatile Tables Within Talend Job

Anonymous — Tue, 26 Jun 2018 16:50:48 GMT

Hi,

I am not very sure of the way teradata works.

with my little understand of Teradata , I am giving my idea.

Use one Teradataconnection at the start of the process and reuse the connection across your job.

use a tTeradatarow component to create volatile table, you can always have the structure of your volatile table in the Metadata(without the actual table)

Use tCloseConnection at the end.

I hope this should help.

Cheers!

Gatha

Re: Creating Volatile Tables Within Talend Job

Anonymous — Tue, 26 Jun 2018 17:07:36 GMT

Thanks for your reply Gatha. That is a good idea and will try it out to see. I'll report back if this was an acceptable solution.

Re: Creating Volatile Tables Within Talend Job

Anonymous — Wed, 27 Jun 2018 20:07:39 GMT

Hi,
Does my idea work?
If so can you please mark the right message as a solution? I guess it's marked on a different message.
Thanks