FROM ADDRESS ADDR
LEFT JOIN COUNTRY_REFERENCE_VIEW VW
ON TRIM (VW.DESCRIPTION) = TRIM (ADDR.COUNTRY)
WHERE TRIM (ADDR.COUNTRY) IS NOT NULL
AND VW.DESCRIPTION IS NULL
AND ( EXISTS
FROM CUSTOMER CUST
WHERE CUST.CUSTOMER_ID = ADDR.CUSTOMER_ID)
FROM PROSPECTIVE_CUSTOMER P_CUST
WHERE P_CUST.UBC_ID = ADDR.CUSTOMER_ID));
This can be done with UDI's in UDI you can join multiple tables but while creating the UDI you have to use one column and table template .. other columns and tables you need to hard code them ... that single column and table comes from the analysis report where you applied this indicator
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.