sunil saini

• Feb 27th, 2007

 

you can do one thing
you use rank transformation make range according the field which represinting duplicasy rows that have more then 1 rank put  get only those rows in target table

Rvinder Ravula

• Apr 3rd, 2007

 

Dear Friend

select * from table_name where rowid not in(select max(rowid) from table_name group by key_column_name);

this query display's the all the duplicate values ...

i dont know in inofrmatica can we write this query in sqloverride ...is it possible???


Thanks
Ravinder Ravula

koustav

• Jul 31st, 2007

 

i think you can write the sql query (delete from....) in session post-sql command and it will work good.

priyank_divya

 Profile Answers by priyank_divya 

• Jul 9th, 2012

 

Hi,

One way of getting only the duplicate columns loaded in the target table is to modify the SQ query:

When primary keys are defined:

select * from where exists (select PK1,PK2,... from
group by PK1,PK2,...
having count(*) > 1)


When primary keys are not defined:

select * from
group by
having count(*) > 1

Thanks.