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

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.

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

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.

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.

After deploying like forms,reports into server how we connect this forms,reports to web?

1 Answers   IBM,

what is meant by lexical parameter

1 Answers   Wipro,

In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?

2 Answers  

which parameters passed in report in oracle developer how to pass

1 Answers   Wipro,

where is chandra institute in hyderabad for oracle apps technical training ?

2 Answers  

we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?

4 Answers  

what is the difference between oracle 8i and 9i?

1 Answers  

difference between 2 way and 4 way matching

3 Answers   Convergys, TCS,

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

2 Answers   IBM, TCS,

Oracle E-Business suite?

2 Answers  

Can u define exceptions twice in same block?

3 Answers  

while doing the process of conversion if got any data error out what is the next step to reprocess

1 Answers