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

which parameters passed in report in oracle developer how to pass

1 Answers   Wipro,


cursor 1 and cursor 2 are there did you open both the cursors at a time or not?

2 Answers   Infosys,


what is inbound and outbound interface?

2 Answers  


what is mutating table and mutating error and how to solve that?

3 Answers  


Can u define DFF with in the DFF,How?

1 Answers   Satyam,


what is the difference between request group and request security in oracle apps?

1 Answers  


How relation will be made between modules in oracle financial?

4 Answers   HCL, Wipro,


How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?

1 Answers  


in which tables the transaction details stored? at least two.

5 Answers   Scan Steel,


how will u do documentation

2 Answers  


can we get profile values in report without using user exists is it possible how?

0 Answers   Cap Gemini,


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

5 Answers   Amdocs,


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)