02-16-2016 01:22 PM
I am facing problem while updating one table from another using key say (product_id). Actually UPDATE transformation has where clause but it is throwing error : something like correlated query .
Could someone help me how to use correlated query in update transform in SAS DI
Problem is like this
Twol table product(prod_id , current_flag) and prod_update(prod_id , current_flag)
update product a inner join prod_update b
I want to Achive DI UPDATE transform .Could someone please help me?