When loading data from staging table to interface table ,
how to reload the invalid record once again ?
Answers were Sorted based on User's Feedback
simple while writing code select the error records also in
main cursor so u can run program again
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / santosh kumar
For validation failed records or error records need to be corrected according to the level of failure and these records can updated with particular status flag (in staging table). And next time validation program has to run only for those records.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / guest
Discarded record will display in out put of loader program
copy the files and load them agin
Is This Answer Correct ? | 8 Yes | 4 No |
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 |
Answer / arun n
Normally it should not load data for the second time.
If the data is not loaded properly, then we need to handle in our custom program for re-processing.
Hope it is clear!!
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / naresh bandla
All the Error record's are stored in Interface Error Tables.
Correct the Error record's and Load this to staging tables and load this from staging to Interface Tables.
Is This Answer Correct ? | 1 Yes | 3 No |
In which table or database definition we can find the link of organization and operation units.
How to know the number of invoices generated for one PO from front end (navigation)?
what is the use of format trigger?a
tell me the scenarios of between pages in reports
How to call oracle database stored procedure from form in form coding ?
How relation will be made between modules in oracle financial?
How can u find custom top? where its located? How to find custom top in front end?
What is an Index , Types od index why we are use index.
If there is any issue then whom do you report.(this is imp question for every interview)
What is the reason for distribution hold. Why invoices will go on distribution variance hold ??
How to create a purchase order without a requisition?
In xml report, how to print the headings in every page?