how to avoid duplicate data while uploading data from flatfile
to staging table? some validations

Answer Posted / jignesh

Create Unique column in staging table and then SQL Loader
will errorout duplicate records and move those records into
BAD files

Please correct me if i am wrong
- makwana.jignesh@gmail.com

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

where to define interorganization transaction charges and what are the different options?

1961


what is global tempory table?

6313


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

1522


what is pay run id ?

1712


Can we create tables in apps schema?

624






What are the different components of soa suite?

727


how do you describe O2C along with tables

2313


Tell me how to debug the report?

643


how to print multi lay outs,muti currency,muti language in xml publisher

10757


how can develope the po variance and po summary report? with tables mandatory columns and query please?

1980


Tell me where we find the status of order information?

669


In sequence i want to 11 and 15th values how we will write?

1575


Explain oracle apps architecture.

767


Which oracle apps version you are very confident in?

707


What are do's and dont's of Interface?

1907