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?
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 |
what is the differences between internal requisition and internal sales order?
In what situation u create the BPA.
How to migrate .rdf file from dev instance to test instance?
3 Answers Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,
Can anybody tell me, What is the Implementation Process?
What is set function in sql .E.g.What is difference between union and union all
what is lexical parameter?
List the various types of value set.
What does appl_top directory contain?
Where we can write a PL/SQL code in report triggers?
how to debug the report?
2 Answers IBM, Qualcomm, Sierra Atlantica,
Where I can download D2K software?
what is tuning in oracle apps technical