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
Is soa a part of oracle fusion middleware?
What do you understand by soa?
How many schemas we have? how many you have used?
can we get profile values in report without using user exists is it possible how?
What is oracle soa suite and what are its different components?
Explain oracle apps architecture.
what is pay run id ?
how can i print random rows in plsql table
What is the concept of soa governance?
In support project one ticket alloted which steps follows manualy tell me ?
How to move the one file from one instance to another instance? And your scripts also?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
Plz anybody send me Technical specification for AP Interface
In hierarchical structure of a database? we have write query from where we should start?
Do you know what is applysys in oracle application database schema, what is apps?