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 Help Members By Posting Answers For Below Questions

is it possible to run the interface without using oracle apps?

1522


What do you understand by soa?

698


please send me forms, xml pulisher questions,answers

1663


tell my any difficult situtation you solved in your experience in your company?

1873


Tell me how to find the custom directory in front end?

668






How do you register report in oracle apps?

636


Which oracle apps version you are very confident in?

709


How many schemas we have? how many you have used?

1618


Do you know what are user profiles in apps. Any examples you can give?

667


What is count(*) from po_vendors(any table)?

645


What is oracle soa suite and what are its different components?

653


What are the different components of soa suite?

728


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?

641


In support project one ticket alloted which steps follows manualy tell me ?

2227


What are file in oracle.

1816