Eliminating of duplicate records without using dynamic lookups

Question Posted / jakki

4 Answers
13807 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Eliminating of duplicate records without using dynamic lookups..

Answer / pooja ahmed

1. you can you use sorter transformation .... in that you
select distinct option

2. use agg trans .... in that go for group by

usi8ng above metyhod you can remove duplicate rec...

Is This Answer Correct ?

6 Yes

0 No

Eliminating of duplicate records without using dynamic lookups..

Answer / bsgsr

duplicate records can be eliminated the following ways:

1) by using select distinct option
2) by over riding sql with group by port on the column
which gets duplicate values ( P_key column)
3) by connecting the source to an expression transformation
and flagging the duplicate records to another target by
writing an expression in the exp editor

Is This Answer Correct ?

3 Yes

0 No

Eliminating of duplicate records without using dynamic lookups..

Answer / bhagya

1) By enabling the option in sorter transformation as
select distinct
(or)
2) By enabling all the values as group by in aggreagator
transformation

Is This Answer Correct ?

3 Yes

1 No

Eliminating of duplicate records without using dynamic lookups..

Answer / raghav

with out distinct we can do it in 3 possible ways.

1. Using Group by function which will act like a distinct in
TD13.0 database

2. using SET table concept, like first we create the multi
set table and insert the duplicate rows into them and then
create the set table and use the insertselcet concept, in
this case only distinct rows will be inserted.

3. use rowid, derived table or sub query concept then we can
do this

Is This Answer Correct ?

1 Yes

0 No

Post New Answer