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
is it possible to run the interface without using oracle apps?
What do you understand by soa?
please send me forms, xml pulisher questions,answers
tell my any difficult situtation you solved in your experience in your company?
Tell me how to find the custom directory in front end?
How do you register report in oracle apps?
Which oracle apps version you are very confident in?
How many schemas we have? how many you have used?
Do you know what are user profiles in apps. Any examples you can give?
What is count(*) from po_vendors(any table)?
What is oracle soa suite and what are its different components?
What are the different components of soa suite?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
In support project one ticket alloted which steps follows manualy tell me ?
What are file in oracle.