how to avoid duplicate data while uploading data from flatfile
to staging table? some validations
- 5 Answers
- 14395 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
Do you know what is applysys in oracle application database schema, what is apps?
In sequence i want to 11 and 15th values how we will write?
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?
How to create a purchase order without a requisition?
can we use look up type instead of a pofile option?or valueset?is it possible how?
Can u give the Documentation of Custom.pll in oracle apps
what is pay run id ?
What do you understand by soa?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
q)what are the validations in sql*loader
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 IS CUSTOM VIEW AND CUSTOM COMPONENT?
Explain oracle apps architecture.
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
