I have a Flat file with more no. of Records also including duplicate values. B

I have a Flat file with more no. of Records also including
duplicate values. But i need distinct values to one target and
remaining records to another target in Informatica way

Question Posted / rahul

2 Answers
5821 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have a Flat file with more no. of Records also including duplicate values. But i need distinct v..

Answer / naveen

1)Use a router , create 2 different groups
2) let both the groups have the same condition in it . eg:
if ur source have got emp _id column and the max value in
it is 1000. Let ur condition in the router be emp_id <= 1000

3) remember , u put both the conditions in the router are
same . Because only then both the groups will fetch full
set of records , eg , if 100 records are ther in the
source , u can get 200 records from these 2 groups totally

4) from the first group, link a sorter or rank
transformation , enable select distinct in that and pass it
to the target

5) connect the other group from the router directly to
another target.

6) enjoy

Is This Answer Correct ?

2 Yes

0 No

I have a Flat file with more no. of Records also including duplicate values. But i need distinct v..

Answer / naveen

1) use the router , create 2 diff groups

2) let both the groups have the same condition , eg: emp_id
> 1000 in both the groups. only then u will all the records
in both the groups

3) use a sorter or rank transformation to enable select
distinct option for the first group and send it to the
target

4) connect the second router group directly to the another
target

5) enjoy

Is This Answer Correct ?

2 Yes

0 No

Post New Answer