Creating Volatile Tables Within Talend Job

[Anonymous]

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!

[Anonymous · Accepted solution]

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

[Anonymous]

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.

[Anonymous]

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