[resolved] How to add index using Talend.

Highlighted
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;

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads