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
please send me forms, xml pulisher questions,answers
tell me the scenarios of the independent in reports
is it possible to run the interface without using oracle apps?
What are the different components you should consider while defining a responsibility in oracle apps?
What does appl_top directory contain?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
Can we create tables in apps schema?
what are the prerequisites for costing transactions?
Can you define an erp system?
How many schemas we have? how many you have used?
q)what are the validations in sql*loader
What are the Standard Reports and Forms in HRMS?
How can you achieve loose coupling in soa framework?
What is a value set? List its various types.
What is oracle soa suite and what are its different components?