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
how can i print random rows in plsql table
List the various types of value set.
What do you understand by concurrent programs?
can we use look up type instead of a pofile option?or valueset?is it possible how?
What are the Standard Reports and Forms in HRMS?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Do you know where we can check the status of po?
How can you achieve loose coupling in soa framework?
How many schemas we have? how many you have used?
Tell me where we find the status of order information?
tell me the scenarios of the independent in reports
What is oracle soa suite?
is it possible to run the interface without using oracle apps?
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
testing tools?