how to avoid duplicate data while uploading data from flatfile
to staging table? some validations
Answer Posted / balaji venkiteela
create an unique index on staging table.
then run the loder program.It autometically omits the
duplicate records,we can find those records in bad file.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
can we use look up type instead of a pofile option?or valueset?is it possible how?
Can you define an erp system?
In sequence i want to 11 and 15th values how we will write?
What is a flexfield? List out its types.
tell me the scenarios of the independent in reports
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
q)what are the validations in sql*loader
List the various types of value set.
Tell me how to debug the report?
Do you know where we can check the status of po?
do you know is it possible to run the interface without using oracle apps?
In support project one ticket alloted which steps follows manualy tell me ?
How do you register report in oracle apps?
Can you differentiate between mediator and osb?
how can i print random rows in plsql table