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

DI Run Table Loader Only If Table Isnt Empty

Reply
New Contributor
Posts: 4

DI Run Table Loader Only If Table Isnt Empty

I would like to run a table loader transformation only if the source table is not empty. I've tried playing around with Conditional Start but I cannot get anything to work.

 

Reason:

We have a source table coming from SQL which is having minor issues currently and our SAS source table will sometimes contain 0 rows, a job on auto scheduler runs and replaces destination table with these 0 rows and this causes problems later on (VA etc). Until this other issue is sorted we would like to only run this loader if rowcount > 0.

 

 Capture.PNG

Super User
Posts: 5,851

Re: DI Run Table Loader Only If Table Isnt Empty

I think you need som kind of user written code that check the source for no of records. You could put this in a User Written node, and then use Conditional Start to check the result from there, or just terminate the SAS session directly.

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 88 views
  • 0 likes
  • 2 in conversation