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

please send me forms, xml pulisher questions,answers

2107


tell me the scenarios of the independent in reports

2499


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

1976


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

1071


What does appl_top directory contain?

1117


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2209


Can we create tables in apps schema?

1130


what are the prerequisites for costing transactions?

3136


Can you define an erp system?

1138


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

2061


q)what are the validations in sql*loader

2399


What are the Standard Reports and Forms in HRMS?

2305


How can you achieve loose coupling in soa framework?

1214


What is a value set? List its various types.

1095


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

1212