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 / pr@$@d

What Nagaraju suggest is right. But instead of creating
temp and then moving those to staging table.

Directrly load the data into staging table and write the
query to eliminate the duplicate rows.

It reduces the one step.

Cheers,
-Pr@$@d.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is pay run id ?

2159


In oracle application how do you debug or trace errors?

1074


What do you understand by a set of books?

1062


What is oracle soa suite?

1194


Can you define an erp system?

1108


Explain oracle apps architecture.

1207


Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1085


Tell me how to debug the report?

1077


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

2017


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

1167


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

2625


What is a value set? List its various types.

1051


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

2044


Can we create tables in apps schema?

1098


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

1046