SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Update Transformation -correlated query

Reply
Learner
Posts: 1

Update Transformation -correlated query

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?

Super User
Posts: 5,257

Re: Update Transformation -correlated query

Why don't you use the Table Loader transformation?
Data never sleeps
Super User
Posts: 5,257

Re: Update Transformation -correlated query

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

Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 222 views
  • 0 likes
  • 2 in conversation