how to avoid duplicate data while uploading data from flatfile
to staging table? some validations
Answer Posted / pr@$@d
What Nagaraju suggest is right. But instead of creating
temp and then moving those to staging table.
Directrly load the data into staging table and write the
query to eliminate the duplicate rows.
It reduces the one step.
Cheers,
-Pr@$@d.
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Can you define an erp system?
What is count(*) from po_vendors(any table)?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Can we create tables in apps schema?
what is global tempory table?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
What is oracle soa suite?
How to create a purchase order without a requisition?
How do you register report in oracle apps?
What do you understand by soa?
Tell me how to debug the report?
How can you achieve loose coupling in soa framework?
Explain what are the tables of auto invoice?
Tell me where we find the status of order information?
can we get profile values in report without using user exists is it possible how?