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?