how to avoid duplicate data while uploading data from flatfile
to staging table? some validations
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What is set function in sql .E.g.What is difference between union and union all
What is Summary columns?
wheather discard file is automatically created or explicty created?can u mention it?
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
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?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
in procedure how to return a value
In unix Schell sript what is very 1st line to be wriiten .
what are the sql attributes?
How does accounting occured in Expense Reporting?
what is instead of trigger in where u will use?