DSXchange

I have 3 different lookups and these 3 lookups have rejections and exceptions. Which is the best method to design the error table? Either to have separate error table for each lookup with the key field, error no,error code, and error description or to have a common error table so that it can be referred ?

Whatever is right for your business. Who is going to look at this error table/these error tables? What do THEY need?

It depends on the way you are going to use it again. Mostly error tables are checked rarely. You are inserting with error number,error code. So why seperate table, store it in single table.

Bury all errors in single table.

The purpose is for the business wants to see the rejected records and to know the reason why it got rejected and for the reconcilation purpose.

And does "the business" want to look at one table or lots of tables?

My personal preference is for a single table - but my personal preference ought not to influence your business users' requirements.