Transformation Stroing 2 SQL query result set and using that in different SQL query

krishu — Mon, 05 Oct 2020 07:48:09 GMT

Hi Team

I have 2 different SQL queries in which the 1st query result (HireDate) will be used in 2nd query to get the MaximumDate and the results from the 1st and 2nd query will be used in the 3rd SQL query to filter the data.

Example:

1st Query: HIRE_DATE = (SELECT NVL(RECENT_HIRE_DATE, SYSDATE - 1) FROM EMPLOYEES WHERE DEP_ID = 'D000001';

2nd Query: MAXIMUM_DATE = SELECT TRUNC(HIRE_DATE + 1) FROM DUAL.

3rd Query: SELECT * FROM EMPLOYEES

WHERE HDATE >= HIRE_DATE AND HDATE < MAXIMUM_DATE;

So my question is how to pass the Query1 result into Query2 and finally Query1 & Query2 results into Query3? Please could anyone help me on designing the job!

Thanks & Regards

Krishu

Re: Transformation Stroing 2 SQL query result set and using that in different SQL query

manodwhb — Mon, 05 Oct 2020 08:45:32 GMT

@sai kris , this is one-way you need to load the results into context and you need to use those. Check the below link to set context.

otherway you can try to use tflowtoiterate component to do the way aslo.

https://help.talend.com/reader/U5lNkhUnaW6RdpL8qxP61w/d0QVvShdlGcIqowdsla3lw

Thanks,

Manohar

topic Transformation Stroing 2 SQL query result set and using that in different SQL query in Talend Studio

Transformation Stroing 2 SQL query result set and using that in different SQL query

Re: Transformation Stroing 2 SQL query result set and using that in different SQL query