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
What are the different components you should consider while defining a responsibility in oracle apps?
What are the benefits of using soa architecture?
How many schemas we have? how many you have used?
Tell me how to debug the report?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
In hierarchical structure of a database? we have write query from where we should start?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
How do you register report in oracle apps?
how can i print random rows in plsql table
What is a value set? List its various types.
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
tell me the scenarios of the independent in reports
In sequence i want to 11 and 15th values how we will write?
In oracle application how do you debug or trace errors?
can we use look up type instead of a pofile option?or valueset?is it possible how?