Update Transformation -correlated query

[Ashisk]

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

 on (a.prod_id=b.prod_id)

set a.current_flag=b.current_flag

I want to Achive DI UPDATE transform .Could someone please help me?

[LinusH]

Why don't you use the Table Loader transformation?

[LinusH]

Since DI Studio is involved, I moved this post to the Data Management forum.