Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9 Answers
- 10797 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
What are batches?
tell me about your project functionality
How many number of sessions can one group in batches?
Explain the shared cache and re-cache?
Explain what is informatica metadata and where is it stored?
How big was your fact table
can you please explain me pre session and post session options?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
what is the hint? how to use it to reduce the query processing in program?
Can informatica load heterogeneous targets from heterogeneous sources?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How can we remove the duplicates from flat file source?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How to load the data from people soft hrm to people soft erm using informatica?
What is joiner transformation?
