topic How to make a job for below sql query in Talend Studio

How to make a job for below sql query

RAJ6 — Sat, 16 Nov 2024 08:34:36 GMT

Hi Talend Folks,

How to make a job for below sql query. I want to know job flow for this query. kindly share your information.

SELECT team, sum(bet) amt_b

FROM ab

WHERE art = 'D' AND soll = 'F'

GROUP BY team

except

SELECT team, sum(bet) amt_c

FROM abc, abcd

WHERE name = 'UBH'
AND dom = art

GROUP BY team

Re: How to make a job for below sql query

Anonymous — Sun, 11 Mar 2018 09:49:23 GMT

You can do this in a single DB input component if you want.... so long as both tables are in the same database.

With main_flow as (
SELECT team, sum(bet) amt_b
FROM ab
WHERE art = 'D' AND soll = 'F'
GROUP BY team),

filter_flow as (
SELECT team, sum(bet) amt_c
FROM abc, abcd
WHERE name = 'UBH'
AND dom = art)

Select 
team, 
amt_b
From main_flow
Where team not in (
Select team
From filter_flow)
GROUP BY team

Otherwise you can use two DB input components and connect using a tMap. The main_flow query in the MAIN table join and the filter_flow in the other DB input connected to a lookup link in the tMap. Then join on team and select catch inner join rejects on the output of the tMap.