Actual does not load.

[xx_emanis]

Hi All,

I have a scenario where my job runs and shows that the data has been processed. But when queried in the target table data is not available.

This happend only when the job fails for any reason, and If I modify the job and rerun it.

If the job runs successfully for the very first time I have created the job then the data loads. Not sure whats happening.

Please guide.

[Anonymous · Accepted solution]

Hello,

Are you able to see any error rows from the reject link?

Best regards

Sabrina

[xx_emanis]

Thank you so much. I have added tsamplerow and was able to identify the rejects and corrected the errors. Now the target table gets loaded correctly.