Interested to Buy Any Domain ? << Click Here >> for more details...
When loading data from staging table to interface table ,
how to reload the invalid record once again ?
- 6 Answers
- 18747 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
WHAT IS THE USE OF SKIP WHERE U WILL GIVE?
How to create a purchase order without a requisition?
LOCKS?
How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/
where we will put the control file ,where we will run sql star loader what is the cmd?
Can we run a package with out specification?If yes how?
In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?
Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232
What are the Import Programs We need to run after creating Interface table for all modules
in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?
How can you achieve loose coupling in soa framework?
why do we validate the records while developing interface?
Oracle Apps Technical 
