Trace Discarded Data

You transfer 100000 rows to target but some records get discarded, How will you trace them and where its get loaded?

Questions by swapnabogolu

Showing Answers 1 - 3 of 3 Answers

sakshi.chopra

  • Sep 26th, 2010
 

The discarded records can be traced from Reject file.
Also optionally you can choose Relational database error logging and the discarded records can be traced from error log tables generated by Integration service.
Also if you choose verbose Tracing, you can also find details of rejected records from session log but this is not a desirable option as it impacts session performance.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions