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


Please Help Members By Posting Answers For Below Questions

Can u give the Documentation of Custom.pll in oracle apps

3217


can we get profile values in report without using user exists is it possible how?

2533


What are the different components you should consider while defining a responsibility in oracle apps?

834


What is a flexfield? List out its types.

888


what is global tempory table?

6738


In support project one ticket alloted which steps follows manualy tell me ?

2416


What do you understand by a set of books?

821


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

3328


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1874


how to print multi lay outs,muti currency,muti language in xml publisher

11479


Tell me how to debug the report?

838


Which oracle apps version you are very confident in?

933


Do you know what is applysys in oracle application database schema, what is apps?

931


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

2112


List the various types of value set.

803