sas di studio 4.2 table loader completes successfully but end table has no data

[saspert]

Hi,

I have a SAS DI studio (v4.21) job running on MS SQL server 2012 R2 environment. The macro etl_loader seems to be running fine but I do not see any data in the end table (Oracle). 

MPRINT(ETLS_LOADER):  ;

NOTE: Appending data ...

MPRINT(ETLS_LOADER):   proc append base = myclient.mytable data = WORK.W6QNWWZK () force

;

MPRINT(ETLS_LOADER):   run;

9                                                          The SAS System                          

   10:49 Thursday, June 30, 2016

NOTE: Appending WORK.W6QNWWZK to myclient.mytable.

NOTE: There were 3287 observations read from the data set WORK.W6QNWWZK.

NOTE: 3287 observations added.

NOTE: The data set myclient.mytable has . observations and 6 variables.

NOTE: PROCEDURE APPEND used (Total process time):

      real time           0.35 seconds

      cpu time            0.11 seconds

NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2016-06-30T10:49:10,537-04:00| _DISARM| WorkspaceSe

rver| _DISARM| SAS| _DISARM| |

      _DISARM| 2749664| _DISARM| 7639040| _DISARM| 10| _DISARM| 10| _DISARM| 8368510| _DISARM| 10774

867| _DISARM| 0.109201|

      _DISARM| 0.359000| _DISARM| 1782917350.178000| _DISARM| 1782917350.537000| _DISARM| 0.046801|

_DISARM| | _ENDDISARM

MPRINT(ETLS_LOADER):  ;

thanks,

saspert

[LinusH]

The no of records in an external RDBMS table is not available to SAS (or Oracle users as well I think, unless table statistics are being instantly updated), so it's just normal.