how to avoid duplicate data while uploading data from flatfile
to staging table? some validations

Answers were Sorted based on User's Feedback



how to avoid duplicate data while uploading data from flatfile to staging table? some validations..

Answer / jignesh

Create Unique column in staging table and then SQL Loader
will errorout duplicate records and move those records into
BAD files

Please correct me if i am wrong
- makwana.jignesh@gmail.com

Is This Answer Correct ?    8 Yes 0 No

how to avoid duplicate data while uploading data from flatfile to staging table? some validations..

Answer / pr@$@d

What Nagaraju suggest is right. But instead of creating
temp and then moving those to staging table.

Directrly load the data into staging table and write the
query to eliminate the duplicate rows.

It reduces the one step.

Cheers,
-Pr@$@d.

Is This Answer Correct ?    5 Yes 2 No

how to avoid duplicate data while uploading data from flatfile to staging table? some validations..

Answer / nagaraju chittamsetty

There is one way to avoid duplicate rows
First transfer the data into temp table by using control
file,this is only temp table.

Second create orginal stagging table then write a query to
eliminate the duplicate rows by taking the rowid.

If anybody got good answer send to me also
my mail id:csnraja@gmail.com

Is This Answer Correct ?    4 Yes 3 No

how to avoid duplicate data while uploading data from flatfile to staging table? some validations..

Answer / 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

how to avoid duplicate data while uploading data from flatfile to staging table? some validations..

Answer / balaji venkiteela

create an unique index on staging table.
then run the loder program.It autometically omits the
duplicate records,we can find those records in bad file.

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Oracle Apps Technical Interview Questions

What is set function in sql .E.g.What is difference between union and union all

2 Answers   IBM, TCS,


What is Summary columns?

1 Answers  


wheather discard file is automatically created or explicty created?can u mention it?

1 Answers   CTS,


what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference

4 Answers   IBM,


How to create a link between One dependent value set to another Dependent value set

5 Answers   Indorama, ManSoft System, Syntel, TE Data,


how to make a parameter optional in the query?

2 Answers   Wipro,


If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

5 Answers   Wipro,


in procedure how to return a value

2 Answers   Wipro,


In unix Schell sript what is very 1st line to be wriiten .

2 Answers   IBM,


what are the sql attributes?

2 Answers  


How does accounting occured in Expense Reporting?

1 Answers   Sapient,


what is instead of trigger in where u will use?

2 Answers   TCS,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)