Interested to Buy Any Domain ? << Click Here >> for more details...
how to avoid duplicate data while uploading data from flatfile
to staging table? some validations
- 5 Answers
- 16397 Views
- Amdocs, I also Faced
- E-Mail Answers
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 |
how to call report from oracle oracle apps11i?
What is cursor?
How many types of projects are there in project module?
6 Answers Fujitsu, Tech Mahindra,
Presently u are working in which version?
we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?
explain o2c cycle? what are the table reflected for this process?
How many standard interface programs in oracle purchasing module and oracle inventory? What are they?
How to call oracle database stored procedure from form in form coding ?
How to know the number of invoices generated for one PO from front end (navigation)?
How many phases of implementation and what are those.
Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232
What is oracle soa suite and what are its different components?
Oracle Apps Technical 
