11-21-2012 01:10 AM
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.
11-21-2012 04:19 AM
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;
11-21-2012 01:17 PM
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.