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 / nagaraju chittamsetty

There is one way to avoid duplicate rows
First transfer the data into temp table by using control
file,this is only temp table.

Second create orginal stagging table then write a query to
eliminate the duplicate rows by taking the rowid.

If anybody got good answer send to me also
my mail id:csnraja@gmail.com

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

12289


Tell me where we find the status of order information?

1140


What are the different components you should consider while defining a responsibility in oracle apps?

1080


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

1097


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

2048


How can we import the data into a database using sql * loader?

1189


how do you describe O2C along with tables

2773


What is sca and how is it useful?

1128


please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3665


What are the Standard Reports and Forms in HRMS?

2319


In oracle application how do you debug or trace errors?

1116


How to create a purchase order without a requisition?

1197


What do you understand by soa?

1160


Can we create tables in apps schema?

1143


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

2078