topic Re: For Executing Complex SELECT Statement with WHERE and GROUP BY Clause - Direct SQL or Talend is best in Talend Studio

For Executing Complex SELECT Statement with WHERE and GROUP BY Clause - Direct SQL or Talend is best

Anonymous — Sat, 16 Nov 2024 04:39:27 GMT

Dear Team,

I am quite new to talend and exploring it functionality.

Recently I came across a complex SQL Select statement something like this,

SELECT COLUMN1, CLOUMN2, CLOUMN3, COUNT(ID) AS EMP_COUNT, AVG(DATEDIFF(YEAR,DOB,GETDATE())) AS AVG_AGE 
FROM TABLE 1
WHERE DOJ <= GETDATE()
AND ISNULL(SEPARATIONDATE, DATE(ADD,D,1,GETDATE()) > GETDATE()
GROUP BY 
COLUMN1, CLOUMN2, CLOUMN3

When I am trying to replicate this select statement using talend components, tDBInput, tCombinedSQLFilter, tCombinedSQLAggregate, tCombinedSQLOutput, tDBCommit,tDBInput, tLogRow. (PFA Screen Shot for reference)

I feel its quite complicated than writing a SQL statement. So could you please suggest me best approach how we can do this kind of transformations using talend.

Thanks in advance.

Re: For Executing Complex SELECT Statement with WHERE and GROUP BY Clause - Direct SQL or Talend is best

manodwhb — Tue, 17 Sep 2019 11:48:19 GMT

@KathikVenky , You can directly use that query in tDBInput and o that the query burden will be on DB side and you can tune that query y adding hints.

Re: For Executing Complex SELECT Statement with WHERE and GROUP BY Clause - Direct SQL or Talend is best

Anonymous — Wed, 18 Sep 2019 06:35:06 GMT

@manodwhb Thank you mano.

Re: For Executing Complex SELECT Statement with WHERE and GROUP BY Clause - Direct SQL or Talend is best

manodwhb — Wed, 18 Sep 2019 06:54:20 GMT

@KathikVenky ,please accept the solution.