[resolved] How to add index using Talend.

One Star

[resolved] How to add index using Talend.

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

Accepted Solutions
Community Manager

Re: [resolved] How to add index using Talend.

Hi
You can use txxxRow component to execute the sql statement.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re: [resolved] How to add index using Talend.

Hi
You can use txxxRow component to execute the sql statement.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] How to add index using Talend.

thanks! it worked Smiley Happy
Gnyanendra
One Star

Re: [resolved] How to add index using Talend.

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

Re: [resolved] How to add index using Talend.

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
One Star

Re: [resolved] How to add index using Talend.

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;