how to avoid duplicate data while uploading data from flatfile
to staging table? some validations
- 5 Answers
- 15421 Views
- Amdocs, I also Faced
- E-Mail Answers
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
how do you describe O2C along with tables
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
tell me the scenarios of the independent in reports
What are the Standard Reports and Forms in HRMS?
Tell me how to find the custom directory in front end?
Do you know what are user profiles in apps. Any examples you can give?
what is global tempory table?
How many schemas we have? how many you have used?
What is sca and how is it useful?
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
Tell me where we find the status of order information?
how to print multi lay outs,muti currency,muti language in xml publisher
Can we create tables in apps schema?
what are the prerequisites for costing transactions?
How can you achieve loose coupling in soa framework?
