Question { Accenture, 17006 }
When loading data from staging table to interface table ,
how to reload the invalid record once again ?
Answer
First to correct the errors may be data errors or Transformation rule errors. Usually any interface table will have batch id. Give a different batch Id and reload the error records after correcting them.
As such we can reload only the error data.