If the flat file is having the duplicate records in the interface how can you r

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?

Question Posted / ravikumar.apps

3 Answers
11463 Views
Accenture, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If the flat file is having the duplicate records in the interface how can you restrict while trans..

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

If the flat file is having the duplicate records in the interface how can you restrict while trans..

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

If the flat file is having the duplicate records in the interface how can you restrict while trans..

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

Post New Answer

More Oracle Apps Technical Interview Questions

what is flexfield qualifier?

3 Answers

in which table sub inventory related information for item is stored?

3 Answers chain sys, Scan Steel,

what is difference between po_headers_all and po_headers

5 Answers Deloitte, Wipro,

Hi All, I have one year experience in Oracle Apps.I want to know that what is value of oracle Apps in market?..I have doubt,here I need to learn Oracle Apps more..because I know the opportunities in market ... otherwise need to learn other technologies ?..... And In Oracle Apps ,which is impotant Functional or technical knowledge ?

2 Answers Wipro,

what is the use of placeholer column?

3 Answers

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

6 Answers Tech Mahindra,

what are the different transaction clauses in AR?

0 Answers BirlaSoft,

how to debug the report?

2 Answers IBM, Qualcomm, Sierra Atlantica,

How relation will be made between modules in oracle financial?

4 Answers HCL, Wipro,

In hierarchical structure of a database? we have write query from where we should start?

0 Answers IBM,

What is menu.

2 Answers Accenture,

What r the validation types?

3 Answers

For more Oracle Apps Technical Interview Questions Click Here