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?
Answer Posted / 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 |
Post New Answer View All Answers
Explain what are the tables of auto invoice?
what are the balancing segments in AR?
Can you differentiate between mediator and osb?
Can u give the Documentation of Custom.pll in oracle apps
How do you register report in oracle apps?
What is oracle soa suite and what are its different components?
please send me forms, xml pulisher questions,answers
tell me the scenarios of the independent in reports
how to print multi lay outs,muti currency,muti language in xml publisher
In hierarchical structure of a database? we have write query from where we should start?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
q)what are the validations in sql*loader
testing tools?
what is global tempory table?
how can i print random rows in plsql table