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

Is soa a part of oracle fusion middleware?

1154


What do you understand by soa?

1193


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

2109


can we get profile values in report without using user exists is it possible how?

2933


What is oracle soa suite and what are its different components?

1281


Explain oracle apps architecture.

1299


what is pay run id ?

2240


how can i print random rows in plsql table

2569


What is the concept of soa governance?

1316


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

2709


How to move the one file from one instance to another instance? And your scripts also?

1171


Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

2439


Plz anybody send me Technical specification for AP Interface

2615


In hierarchical structure of a database? we have write query from where we should start?

2298


Do you know what is applysys in oracle application database schema, what is apps?

1219