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
- 16568 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 register a form and stored procedure in oracle apps
1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function
How can u call a standard interface program from sql or pl/sql code?
Difference between set of books id and ledger id in r12 ?
what is difference between procedure and function
what is the defference between credit memo and debit memo
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Registering parametric report?
is UOM maintained at master level or organization level or both?
in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me
If there is any issue then whom do you report.(this is imp question for every interview)
what is item status? name the related table.
Oracle Apps Technical 
