topic Re: Talend Open Studio, tOracleOutput and Action on table and Indexes in Talend Studio

Talend Open Studio, tOracleOutput and Action on table and Indexes

Anonymous — Sat, 16 Nov 2024 13:02:41 GMT

I have a tOracleOutput that has "Drop and Create table" as "Action on table". The problem is that when it drops the table, it drops all of the indexes, except the primary key index, which is being recreated with different name, everytime I run the job. If I choose "Clear Table", it takes twice as long to run the job. It doesn't seem that there is any option for me to create or import indexes for tables in Talend Open Studio when I import the schema. Is there anything that I can do different? Or is there any other way to have indexes in Talned Schema?

Re: Talend Open Studio, tOracleOutput and Action on table and Indexes

Anonymous — Fri, 11 Mar 2011 01:27:40 GMT

Hi
No, it is impossible to define indexs on Talend schema. To create a table with index, you can use the tOracleRow to execute the SQL.
Best regards
Shong

Re: Talend Open Studio, tOracleOutput and Action on table and Indexes

Anonymous — Thu, 23 Aug 2018 22:38:46 GMT

Hi ,

I am new to Talend ETL, I do have the same problem, I am trying to clear the table before inserting the data, it takes hours and didn't complete the job. Do you have any suggestion for this issue?

Re: Talend Open Studio, tOracleOutput and Action on table and Indexes

Anonymous — Wed, 29 Aug 2018 19:36:23 GMT

Hi,

If you would like to just clear the entire table before data load (keeping the table structure without drop), you can use the Truncate Table option in the Action on table. It will be faster compared to clear table as no DB logs will be generated in this option.

Warm Regards,

Nikhil Thampi