how to avoid duplicate data while uploading data from flatfile
to staging table? some validations

Answer Posted / srinivas.r

Yes,directly we can't handle the duplicate rows from the
SQLLOQDER, for that first we move the data into temp table
from flatfile.After that create the Staging talbe then make
validations before moving into staging table.

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can develope the po variance and po summary report? with tables mandatory columns and query please?

1982


How to create a purchase order without a requisition?

636


How many schemas we have? how many you have used?

1618


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1806


How can a process be deployed in soa?

704






What do you understand by concurrent programs?

627


Can you explain the difference between architecture followed in 10g & 11g?

669


Which oracle apps version you are very confident in?

710


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

651


How is choreography different from orchestration?

660


Tell me where we find the status of order information?

675


What is the concept of soa governance?

776


What are file in oracle.

1816


Explain what are the tables of auto invoice?

650


what are the balancing segments in AR?

1657