topic Re: Execute SQL task before starting a Job in Talend Studio

Execute SQL task before starting a Job

Anonymous — Wed, 14 Aug 2019 15:58:16 GMT

Hello Everyone,

I would like to know what is the component used to execute an sql task before running a Job. I would like to truncate my fact tables before loading them. I've used 'execute sql task' component in SSIS for the above problem.

I've tried looking for tMSQLrow component in the pallete but was not able to find it. Instead I found tHiveRow(not sure if it's the right component) which requires external jar's to be installed.

Please help me with this.

Thanks and regards,

Praneeth Reddy Varimalla

Re: Execute SQL task before starting a Job

JR1 — Thu, 15 Aug 2019 08:09:31 GMT

Have you tried the component tDBRow and then select the DB type "MySQL" or "MSSQL" (not sure which one you use) in the component parameters? Since Talend 7.X the component will automatically change to a tMySQLRow or tMSSQLRow component after you do this.

Re: Execute SQL task before starting a Job

Anonymous — Thu, 15 Aug 2019 19:58:13 GMT

Hello JR,

Thanks a lot! That works.