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 / swapna
AFTER LOADING THE DATA INTO STAGE TABLE USING SQL LOADER,
WE WILL WRITE THE VALIDATION PROGRAM.
IN THIS VALIDATION PROGRAM WE WILL WRITE CODE TO RESTRICT
DUPLICATE RECORDS.
SO ONLY VALID RECORDS ONLY TRANSFERRED INTO INTERFACE TABLE.
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What do you understand by soa and what are the benefits of using this architecture?
What is oracle soa suite?
What do you understand by a set of books?
Are you familiar with internet architecture of oracle apps 11i?
What is sca and how is it useful?
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?
List the various types of value set.
Which oracle apps version you are very confident in?
do you know is it possible to run the interface without using oracle apps?
How to create a purchase order without a requisition?
What is instead of trigger in where we will use?
Can u give the Documentation of Custom.pll in oracle apps
is it possible to run the interface without using oracle apps?
please send me forms, xml pulisher questions,answers