How to deal with rejected rows?

NOTE : [This question was asked by Sri]

Write them in a separate target file. Ideally , there should be no database level rejects. Only at the router level , which you can send to a flat file.

using reject load utility get the reject file as the source again and apply the business rules after cleansing.

Can you please elaborate your question, that what type of your output that you need from the geeks...

__________________
Sanghala
www.dwforum.net - A Great resource for Data Warehousing Professionals

If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.