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
- 11749 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 |
what is difference between d2k report and oracle apps report
what are the tables of auto invoice.
What is the difference between BPA AND Contract.
How to send the e-mail notification in XML Pub Report?
How to register a form and stored procedure in oracle apps
What is function?
In hierarchical structure of a database? we have write query from where we should start?
In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?
what are the error tables in AP?
In developer Reports::there are 3 parameters.can you pass the paramter1+paratmeter2 value to the third parameter??
Can you differentiate between mediator and osb?
How will U link GL with OU in Multi-org environment.
Oracle Apps Technical 
