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
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?
How is choreography different from orchestration?
Explain oracle apps architecture.
what is the differences between internal requisition and internal sales order?
What is oracle soa suite and what are its different components?
q)what are the validations in sql*loader
What do you understand by soa?
testing tools?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
is it possible to run the interface without using oracle apps?
What are the different components you should consider while defining a responsibility in oracle apps?
Do you know what is applysys in oracle application database schema, what is apps?
What are the different components of soa suite?
Are you familiar with internet architecture of oracle apps 11i?
tell me the scenarios of the independent in reports