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 create tables in apps schema?
tell my any difficult situtation you solved in your experience in your company?
how can i print random rows in plsql table
Do you know where we can check the status of po?
How to create a purchase order without a requisition?
Tell me where we find the status of order information?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
How to move the one file from one instance to another instance? And your scripts also?
What is sca and how is it useful?
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 to print multi lay outs,muti currency,muti language in xml publisher
How can a process be deployed in soa?
What do you understand by concurrent programs?
How is choreography different from orchestration?