Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am moving a large amount of data (over 30 million rows) and getting a different count between the source and destination.
My source database is SQL Server and destination is Snowflake.
Even though I have added a reject route to an delimited file - I am not getting anything in the reject file.
Here is a screen shot of my job.
Hello,
What's operation are you using in tMap component? Would you please let us know which steps your row count is changed? Row1 or AUDITITEM? Could you please try to use tLogRow instead of an delimited file to see if your rejected rows are captured on console?
Best regards
Sabrina