Talend Open Studio, tOracleOutput and Action on table and Indexes

One Star

Talend Open Studio, tOracleOutput and Action on table and Indexes

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?
Community Manager

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

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
Five Stars

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

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?

Employee

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

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.

image.png

 

 

Warm Regards,

 

Nikhil Thampi