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

DI Studio - Unresolved reference to table/correlation name in Delete task

Reply
New Contributor
Posts: 3

DI Studio - Unresolved reference to table/correlation name in Delete task

I'm running an extract from a SQL Server table.  Before I load into my destination table, I want to remove any keys in the destination table that have a match in the work table (W8T0KH11) I produced from my extract task.

 

The destination table has a PK on 'TransactionKey'.  If I don't run the deletion, the proc append that is run in the Table Loader errors due to the key already existing.  The reason I want to delete and re-append is because the rows have been updated at source.

 

In the delete task, I have said where W8T0KH11.TransactionKey = DirectoryBaskets.TransactionKey.  This fails when I try to run the delete stating "ERROR: Unresolved reference to table/correlation name W8T0KH11."  

 

I'm of the opinion that for some reason the work table is not being created before I try to run the delete.  From the log it is defined and then immediately moves to process delete.

 

I want to have these deletions run before the table loader and appreciate any pointers.

 

Flow screenshot :

Delete key flow task.png

Super User
Posts: 5,483

Re: DI Studio - Unresolved reference to table/correlation name in Delete task

Posted in reply to Tom_Bailey
Spontanously it sounds more of a syntax rather than an execution error, a full log might answer that.
But I think you are doing this a bit more complicated than needed. The Table Loader transform lets you either update/overwrite rows on existing keys, or just skip adding them (which to chose depends on the purpose of the target table).
Data never sleeps
New Contributor
Posts: 3

Re: DI Studio - Unresolved reference to table/correlation name in Delete task

Hi,

 

Thanks for the response.

 

If you mean the Update/Insert Load style, I found this was performing individual loops per row.  I have 700k+ rows to analyse and it was taking far too long (and had run up some impressive size logs).

New Contributor
Posts: 3

Re: DI Studio - Unresolved reference to table/correlation name in Delete task

Posted in reply to Tom_Bailey

.... actually looks like that was due to the technique I was using.  Modify by index looks OK.

 

Thanks

Ask a Question
Discussion stats
  • 3 replies
  • 122 views
  • 0 likes
  • 2 in conversation