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 / sharad

define primary or unique key on staging table then it
restricts duplicate data when u run sqlloader for
transfering data from flat file to staging table

Is This Answer Correct ?    14 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle soa suite?

860


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?

745


testing tools?

1857


Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

1688


How to create a purchase order without a requisition?

736






How can you achieve loose coupling in soa framework?

827


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

736


please send me forms, xml pulisher questions,answers

1772


What are the benefits of using soa architecture?

799


Do you know where we can check the status of po?

747


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1735


What are the Standard Reports and Forms in HRMS?

1855


what is the difference between request group and request security in oracle apps?

5210


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2689


can we use look up type instead of a pofile option?or valueset?is it possible how?

1866