Update Redshift table based on CTE values

mramachandran — Fri, 15 Nov 2024 23:39:52 GMT

I am very new to talend. I have an existing on-prime ETL process for SQL server, moving to Red-Shift. It is a typical File to DB data load and clean-up the data. I was able to convert the File to DB process in Talend. Quite stuck with the cleanup process that exists in current process. The ETL process invokes an Stored Procedure, little complex (multiple temp tables and several CTEs) to find the country from an address based on string patterns. I have been trying to achieve this complex query in tDBRow. I am not sure, i can able to achieve this in Talend tDBRow component.

The routines starts like this

with cte1 as (select address1 + address2 + address3 as AddressText from customeraddress)

, zip as (Select case when right (AddressText, 5) like '%[0-9]%' then

right (AddressText, 5) else when case when "logic2" then '' end zipcode , * from cte

) ...

Please advise me here on the best approach.

Re: Update Redshift table based on CTE values

Anonymous — Fri, 15 Oct 2021 08:02:59 GMT

To select fields in a query, we usually use tDBInput component, try with tDBInput component and let us know if you have any troubles.

Regards

Shong

topic Update Redshift table based on CTE values in Data Quality

Update Redshift table based on CTE values

Re: Update Redshift table based on CTE values