1 of 1 people found this helpful
I'd suggest changing the target to a flatfile as a test. If the data gets written to the flatfile target, the issue is in the write to the database.
If nothing is written to the file, it's further back in the mapping?
You can also try adding a Expression Tx immediately before the database target object in the mapping and run a Data Preview to verify the data is getting that far.
Thanks for the suggestion, let me try with flat file and get back.
If the issue is still not resolved, I would suggest you to look into the mapping logs for "transformation errors". As per default behaviour, if there is a transformation error for a particular row, that row will be skipped. If you need any help with that, you share the mapping logs or open a case to assist you further.
One such example of transformation error:
2020-09-16 07:06:05.258 <TASK_10568-TRANSF_1_1_1> SEVERE: [TT_11131] Transformation [Router_r1] had an error evaluating variable column [PARTY_ID_out]. Error message is [<<Expression Error>> [ERROR]: transformation error
... u:ERROR(u:'transformation error')].
Sorry, I'm busy with different work which is on priority. may be next week I will resume this work,