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
Can you explain the difference between architecture followed in 10g & 11g?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
tell me the scenarios of the independent in reports
Are you familiar with internet architecture of oracle apps 11i?
What is oracle soa suite?
Explain what are the tables of auto invoice?
Can you define an erp system?
What does appl_top directory contain?
What are the different components you should consider while defining a responsibility in oracle apps?
List the types of flexfield?
q)what are the validations in sql*loader
how do you describe O2C along with tables
Tell me where we find the status of order information?
How many schemas we have? how many you have used?
What is a value set? List its various types.