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

tell me the scenarios of the independent in reports

2243


Can you define an erp system?

875


What are file in oracle.

2000


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

821


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2339


what are the balancing segments in AR?

1836


What do you understand by a set of books?

821


how can i print random rows in plsql table

2137


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1964


Explain what are the tables of auto invoice?

871


Explain oracle apps architecture.

998


What are the Standard Reports and Forms in HRMS?

1964


What do you understand by concurrent programs?

796


What is a value set? List its various types.

844


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

1796