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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / srinivas.r
We can't restrict the duplicate records by using the SQL
*Loader.For that first move the data into Staging table and
then alidate the records before moving into interface table.
This is the process i knnow as per my knowledge.
Is This Answer Correct ? | 2 Yes | 0 No |
What are file in oracle.
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
what is pick selection list generation report.
How many parameters we can pass through pl/sql program in Oracle apps
Are there any alternate tools other than sql* loader to load data into oracle apps tables from external systems
What are triggers?
why r u transer the data base tables to flat file and what is use
what are the default arguments for pl/sql program?
what is meant by lexical parameter
How to know the number of invoices generated for one PO from front end (navigation)?
why do we go for oracle apps technical other than sap and other packages?
I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????