how to avoid duplicate data while uploading data from flatfile
to staging table? some validations
Answer Posted / pr@$@d
What Nagaraju suggest is right. But instead of creating
temp and then moving those to staging table.
Directrly load the data into staging table and write the
query to eliminate the duplicate rows.
It reduces the one step.
Cheers,
-Pr@$@d.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
what is pay run id ?
In oracle application how do you debug or trace errors?
What do you understand by a set of books?
What is oracle soa suite?
Can you define an erp system?
Explain oracle apps architecture.
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Tell me how to debug the report?
How many schemas we have? how many you have used?
What is oracle soa suite and what are its different components?
In support project one ticket alloted which steps follows manualy tell me ?
What is a value set? List its various types.
In sequence i want to 11 and 15th values how we will write?
Can we create tables in apps schema?
What is count(*) from po_vendors(any table)?