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

Issue with table loader

Reply
Contributor
Posts: 23

Issue with table loader

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.

Super User
Posts: 5,428

Re: Issue with table loader

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;

Data never sleeps
Super Contributor
Posts: 349

Re: Issue with table loader

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

Ask a Question
Discussion stats
  • 2 replies
  • 199 views
  • 0 likes
  • 3 in conversation