how can one eliminate dupliacte data with out using distinct option?

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

how can one eliminate dupliacte data with out using
distinct option?

Question Posted / harish

5 Answers
11172 Views
Patni, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can one eliminate dupliacte data with out using distinct option?..

Answer / sunil

By using aggrator select groupby port to eliminate
duplicates

Is This Answer Correct ?

31 Yes

0 No

how can one eliminate dupliacte data with out using distinct option?..

Answer / prabha kamaraj

Using Group by command removes all duplicates records in a
table

Is This Answer Correct ?

5 Yes

0 No

how can one eliminate dupliacte data with out using distinct option?..

Answer / sujatha

in the sq data has to be order by key column..then in the
expression trans we have to create a variable port to hold
the previous records key value...and one more variable port
to compare with the current records key value...if the prev
and curr are equal then the 2nd variable value will
get 'Y',if not equal its value will be 'N'.
Take a router ,process the rows which are having the 2nd
variable value as 'N' to the target....these are unique recs

Is This Answer Correct ?

4 Yes

0 No

how can one eliminate dupliacte data with out using distinct option?..

Answer / ankit kansal

An Alternative way
Using Rank Transformation select group by all and only select only those rows whose indexes are one.

http://deepinopensource.blogspot.in/

Is This Answer Correct ?

1 Yes

0 No

how can one eliminate dupliacte data with out using distinct option?..

Answer / arpan

U can use Sorter Transformation and there is an option as
Select Distinct.

Is This Answer Correct ?

3 Yes

6 No

Post New Answer