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
testing tools?
In sequence i want to 11 and 15th values how we will write?
can we use look up type instead of a pofile option?or valueset?is it possible how?
How to move the one file from one instance to another instance? And your scripts also?
How can a process be deployed in soa?
What does appl_top directory contain?
Tell me where we find the status of order information?
where to define interorganization transaction charges and what are the different options?
Tell me how to find the custom directory in front end?
What is a value set? List its various types.
What are the Standard Reports and Forms in HRMS?
Explain what are the tables of auto invoice?
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
How can we import the data into a database using sql * loader?
Are you familiar with internet architecture of oracle apps 11i?