1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to avoid duplicate data while uploading data from flatfile to staging table?

Discussion in 'Oracle Apps Technical' started by naveen.lazaus, Apr 20, 2017.

  1. naveen.lazaus

    naveen.lazaus Active Member

    Messages:
    3
    Likes Received:
    2
    Trophy Points:
    85
    how to avoid duplicate data while uploading data from flatfile to staging table?
     
  2. Kolguri Ravi Kumar

    Kolguri Ravi Kumar Premium Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    Hyderabad
    Create Unique column in staging table and then SQL Loader
    will errorout duplicate records and move those records into
    BAD files