If the flat file is having the duplicate records in the
interface how can you restrict while transferring the flat
file data in to interface tables?
Answer Posted / srinivas.r
We can't restrict the duplicate records by using the SQL
*Loader.For that first move the data into Staging table and
then alidate the records before moving into interface table.
This is the process i knnow as per my knowledge.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
please send me forms, xml pulisher questions,answers
What is a flexfield? List out its types.
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
where to define interorganization transaction charges and what are the different options?
testing tools?
can we get profile values in report without using user exists is it possible how?
Plz anybody send me Technical specification for AP Interface
Tell me where we find the status of order information?
What are the different components you should consider while defining a responsibility in oracle apps?
Can you explain the difference between architecture followed in 10g & 11g?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
what are the prerequisites for costing transactions?
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
q)what are the validations in sql*loader