Interested to Buy Any Domain ? << Click Here >> for more details...
If the flat file is having the duplicate records in the
interface how can you restrict while transferring the flat
file data in to interface tables?
- 3 Answers
- 11555 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swapna
AFTER LOADING THE DATA INTO STAGE TABLE USING SQL LOADER,
WE WILL WRITE THE VALIDATION PROGRAM.
IN THIS VALIDATION PROGRAM WE WILL WRITE CODE TO RESTRICT
DUPLICATE RECORDS.
SO ONLY VALID RECORDS ONLY TRANSFERRED INTO INTERFACE TABLE.
| Is This Answer Correct ? | 18 Yes | 0 No |
Answer / sharad
define primary or unique key on staging table then it
restricts duplicate data when u run sqlloader for
transfering data from flat file to staging table
| Is This Answer Correct ? | 14 Yes | 2 No |
Answer / srinivas.r
We can't restrict the duplicate records by using the SQL
*Loader.For that first move the data into Staging table and
then alidate the records before moving into interface table.
This is the process i knnow as per my knowledge.
| Is This Answer Correct ? | 2 Yes | 0 No |
Types of cursors?
What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.
Tell me where we find the status of order information?
what is global tempory table?
HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT
How to print multi currency,multi language in xml?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
what is multi org structure?
What are the benefits of using soa architecture?
Give a overview on Aol
Do you know what is applysys in oracle application database schema, what is apps?
what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .
Oracle Apps Technical 
