Create Teradata volatile tables inside a Talend job

Jorjos — Fri, 31 May 2019 09:45:17 GMT

Hi,

I'm trying to create a Teradata volatile table in a Talend Job but I always fail.

I use one tTeradataconnection at the start of the flow, and connect to a tTeradatarow component where I create the volatile table.

Then I want to use the volatile table that I've created inside a tTeradataInput sql query to filter because it has to process a lot of rows but i get the next error:

[FATAL]: local_project.prueba_tabla_volatil_0_1.Prueba_tabla_volatil - tDBInput_1 [Teradata Database] [TeraJDBC 16.20.00.10] [Error 3807] [SQLState 42S02] Object 'VOLATILE' does not exist.

I attach an image from the job.

It's like the volatile table it's created at tTeradatarow but disappear in the same component...

Any help would be appreciated!

Thanks!

Re: Create Teradata volatile tables inside a Talend job

Anonymous — Fri, 31 May 2019 22:55:54 GMT

Hi,

The contents of volatile tables are only retained for the duration of a session. So it will not be a good idea to use if your data is flowing across multiple sessions.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

topic Re: Create Teradata volatile tables inside a Talend job in Talend Studio

Create Teradata volatile tables inside a Talend job

Re: Create Teradata volatile tables inside a Talend job