Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / balaji venkiteela

create an unique index on staging table.
then run the loder program.It autometically omits the
duplicate records,we can find those records in bad file.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can we use look up type instead of a pofile option?or valueset?is it possible how?

2264


Can you define an erp system?

1222


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

2132


What is a flexfield? List out its types.

1226


tell me the scenarios of the independent in reports

2658


Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

2087


q)what are the validations in sql*loader

2456


List the various types of value set.

1122


Tell me how to debug the report?

1172


Do you know where we can check the status of po?

1361


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

1163


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

2710


How do you register report in oracle apps?

1134


Can you differentiate between mediator and osb?

1193


how can i print random rows in plsql table

2571