When loading data from staging table to interface table ,
how to reload the invalid record once again ?

Answer Posted / manaswinig

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.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the tables of auto invoice?

650


What are do's and dont's of Interface?

1909


where to define interorganization transaction charges and what are the different options?

1963


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2133


How to move the one file from one instance to another instance? And your scripts also?

617






How is choreography different from orchestration?

660


what is the differences between internal requisition and internal sales order?

2163


What are file in oracle.

1816


What is count(*) from po_vendors(any table)?

645


What are the benefits of using soa architecture?

711


In hierarchical structure of a database? we have write query from where we should start?

1712


pls send me out bound code of supplers,site,bankiformation code pls as soon as

1763


What is oracle soa suite?

771


In sequence i want to 11 and 15th values how we will write?

1577


what is the difference between request group and request security in oracle apps?

5059