Create Teradata volatile tables inside a Talend job

[Jorjos]

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!

[Anonymous]

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 🙂