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
how to print multi lay outs,muti currency,muti language in xml publisher
Tell me where we find the status of order information?
What are the different components you should consider while defining a responsibility in oracle apps?
Do you know what are user profiles in apps. Any examples you can give?
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
How can we import the data into a database using sql * loader?
how do you describe O2C along with tables
What is sca and how is it useful?
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
What are the Standard Reports and Forms in HRMS?
In oracle application how do you debug or trace errors?
How to create a purchase order without a requisition?
What do you understand by soa?
Can we create tables in apps schema?
In sequence i want to 11 and 15th values how we will write?