Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. I`m a new in Talend.
Making a new development format with Talend, I have a trouble with common SQL.
I`d like to make common SQL to get common value each job and tried below.
I chose tSQLTemplate to set SELECT SQL
but tSQLTemplateAggregate.
but I don`t know how I can use tSQLTemplate properly. Talend manual said just detail of component but usage.
Is there somebody who help me plaese?
like connection usage,
tDBConnection - tSQLTemplate - nextComponent(?)
Hello,
As a start component, tSQLTemplate component is used with other database components, especially the database connection and commit components.
Such as, tDBConnection -->OnSubjobOK--> tSQLTemplate_1 --> tDBClose
Best regards
Sabrina