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 u give the Documentation of Custom.pll in oracle apps
can we get profile values in report without using user exists is it possible how?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
what is the differences between internal requisition and internal sales order?
What does appl_top directory contain?
How can we import the data into a database using sql * loader?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
List the types of flexfield?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
How many schemas we have? how many you have used?
How is choreography different from orchestration?
Is soa a part of oracle fusion middleware?
tell me the scenarios of the independent in reports
Explain what are the tables of auto invoice?