how to avoid duplicate data while uploading data from flatfile
to staging table? some validations
Answer Posted / jignesh
Create Unique column in staging table and then SQL Loader
will errorout duplicate records and move those records into
BAD files
Please correct me if i am wrong
- makwana.jignesh@gmail.com
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Which oracle apps version you are very confident in?
Do you know where we can check the status of po?
tell my any difficult situtation you solved in your experience in your company?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
Can you differentiate between mediator and osb?
How can we import the data into a database using sql * loader?
how can i print random rows in plsql table
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
What are file in oracle.
How many schemas we have? how many you have used?
What is count(*) from po_vendors(any table)?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
what is pay run id ?
List the various types of value set.