topic Re: Source tables may not be populated before transformation runs in SAS Data Management

Source tables may not be populated before transformation runs

Shukhrat — Thu, 06 Feb 2020 13:58:14 GMT

Hello
I have the following problem in SAS DI.
The following warning appears in the control flow window, see screen

Here is a chart

Who faced this, please tell me how to fix it? Does the warning affect the result or speed of the process?

Thanks in advance.

Re: Source tables may not be populated before transformation runs

ErikLund_Jensen — Thu, 06 Feb 2020 16:58:41 GMT

Hi @Shukhrat

I think it might be caused by the same table being used as input and output. It is just a guess, because a storage system problem prevents me from testing it today, but DI Studio might detect that the table is populated in the insert transformation 3, so it might happen that the table is empty when it is used as input to the join transformation 1. I can't see how it could have any impact on speed or result.

So if the job is complete, i.e. it is able to execute, and the output is as expected, I think you can ignore the warning. Warnings from Flow Control often disappears when the job is saved/closed and opened again. Did you try that?

Re: Source tables may not be populated before transformation runs

Shukhrat — Fri, 07 Feb 2020 10:21:54 GMT

Thanks for the clarification