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

[resolved] How to add index using Talend.

Anonymous — Sat, 16 Nov 2024 12:32:56 GMT

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

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

Anonymous — Fri, 25 Nov 2011 06:38:25 GMT

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

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

Anonymous — Tue, 29 Nov 2011 12:02:23 GMT

thanks! it worked
Gnyanendra

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

Anonymous — Tue, 06 Dec 2011 07:42:35 GMT

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

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

Anonymous — Wed, 07 Dec 2011 15:32:23 GMT

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

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

Anonymous — Thu, 08 Dec 2011 11:54:54 GMT

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;