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 / 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 |
Post New Answer View All Answers
What are the different components you should consider while defining a responsibility in oracle apps?
What do you understand by soa?
what are the different transaction clauses in AR?
What is count(*) from po_vendors(any table)?
What are do's and dont's of Interface?
Can you explain the difference between architecture followed in 10g & 11g?
tell me the scenarios of the independent in reports
In sequence i want to 11 and 15th values how we will write?
do you know is it possible to run the interface without using oracle apps?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Do you know what is applysys in oracle application database schema, what is apps?
tell my any difficult situtation you solved in your experience in your company?
What is oracle soa suite?
testing tools?
What is the concept of soa governance?