topic Re: Issue with table loader in SAS Data Management

Issue with table loader

Sandhyaa — Wed, 21 Nov 2012 06:10:29 GMT

We could see the result dataset upto SQL joins in a job. But the next transformation table loader is not working. It is not throwing any errors or warnings as well. Executions seems to be successful. But we could not find the records in the target dataset. Same issue exists across several jobs.

Kindly suggest ideas of where to check to solve this issue.

Re: Issue with table loader

LinusH — Wed, 21 Nov 2012 09:19:53 GMT

What update method do you use?

What DBMS do you use for the target tables?

If there something about the logic in the table loader, this could normally be found in the log (e.g. no of records in the different work tables used in table loader).

If you load to an external RDBMS, using SAS/ACCESS debugging will help you see the RDBMS specific SQL syntax for the update:

options SASTRACE=',,,d' SASTRACELOC=SASLOG;

Re: Issue with table loader

shivas — Wed, 21 Nov 2012 18:17:33 GMT

I guess there would be mapping issue.Just check if your source column and target column are mapped correctly in Mapping tab in table loader transformation.

If the source col and target col are not same then you need to do manually mapping each source to target variable(automatic mapping will not work if column names are different).

As suggested by Linus you an check the log for more information.

Thanks,

Shiva