how to avoid duplicate data while uploading data from flatfile
to staging table? some validations
Answer Posted / nagaraju chittamsetty
There is one way to avoid duplicate rows
First transfer the data into temp table by using control
file,this is only temp table.
Second create orginal stagging table then write a query to
eliminate the duplicate rows by taking the rowid.
If anybody got good answer send to me also
my mail id:csnraja@gmail.com
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
what is global tempory table?
In oracle application how do you debug or trace errors?
How is choreography different from orchestration?
What are the different components you should consider while defining a responsibility in oracle apps?
Do you know what is applysys in oracle application database schema, what is apps?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
What do you understand by a set of books?
What is count(*) from po_vendors(any table)?
Do you know where we can check the status of po?
What are the benefits of using soa architecture?
what is the difference between request group and request security in oracle apps?
How can a process be deployed in soa?
What does appl_top directory contain?
List the types of flexfield?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?