src->sq->aggregator->router->target1

hi all hi have flat file like below my requirement is
empid,ename,sal,loc
101,vamshi,5000,hyd
101,vamshi,5020,hyd
201,raju,5000,hyd
202,ram,4000,hyd
203,kumar,3500,pune
203,kumar,3500,pune
203,kumar,5000,hyd
203,kumar,6000,hyd
i want the o/p like this
in one target
201,raju,5000,hyd
202,ram,4000,hyd
and in second target
101,vamshi,5000,hyd
101,vamshi,5020,hyd
203,kumar,3500,pune
203,kumar,3500,pune
203,kumar,5000,hyd
203,kumar,6000,hyd

Question Posted / abhishek guddu

9 Answers
10683 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / abhishek guddu

src->sq->aggregator->router->target1
|->target2
AggregatorT/F

EMPID -> (GROUP BY)
O_COUNTID(EMPID)-OUTPUT PORT
<- COUNT(EMPID)> 1
ROUTER T/F
GROUP
ONE - CONDITION-> 0_COUNTID ->TARGET1(SECOND TARGET)
DEFAULT->TARGET2(TWO TARGET)

ONE GROUP RETURN DUPLICATE EMPID AND DEFAULT WILL UNIQUE.

Is This Answer Correct ?

6 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to join three sources using joiner?

1078

What is informatica?

1129

What is the difference between informatics 7x and 8x and what is latest version?

1063

Can informatica load heterogeneous targets from heterogeneous sources?

1172

What does “tail –f” command do and what is its use as an Informatica admin.

1078

Explain the features of connected and unconnected lookup.

917

What are data-driven sessions?

1181

Whats there in global repository

1672

Explain the informatica workflow?

1035

Design time, run time. If you don't create parameter what will happen

1826

How to join three sources using joiner? Explain though mapping flow.

1126

can we override a native sql query within informatica? Where do we do it?

1096

What is resilience time?

1105

How do you load first and last records into target table?

1139

How can you validate all mappings in the repository simultaneously?

1349