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?
1 REPLY
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