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 r the validation done in ap inbound ?
how many groups we can create for query?
Explain oracle apps architecture.
what is the difference between procedure and function
Can we create tables in apps schema?
How to print multi currency,multi language in xml?
what is difference between d2k report and oracle apps report
10 Answers Seven Hills, Wipro,
any one can expalin report registration steps?
In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?
What is a flexfield? List out its types.
AOL?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?