Hi
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.
