[resolved] How to add index using Talend.

[Anonymous]

Hi,
I need to make my ETL process fast. So I want to first DROP the existing INDEX in tables and run the entire job and when job has finished, want to ADD INDEX again. Please suggest a way to do this.
I'm getting error 'Can not issue data manipulation statements with executeQuery()' using tMysqlInput-Output pair.
thanks
Gnyanendra

[Anonymous · Accepted solution]

Hi
You can use txxxRow component to execute the sql statement.
Best regards
Shong

[Anonymous]

thanks! it worked
Gnyanendra

[Anonymous]

Hi,
What's the txxxrow? I couldn't find it in talend's 4.2.1 version.
Thanks in advance

[Anonymous]

cinar,
The "xxx" depends on the database you are using. For an mssql database the component will be "tmssqlrow" for example. For tmysql it will be "tmysqlrow" etc..
Hope it helps,
Regards

[Anonymous]

Hi Mpa,
Thanks for your response. But I wanna ask you one more thing. What should I type in the query area of the tOracleRow for indexing?
Can the component generate the following code If I write it in the query area of the component?
CREATE INDEX mydatabase.INDX_mytable ON mydatabase.mytable
(ID1, ID2)
NOLOGGING
TABLESPACE DETAILER_INDEX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;