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
- 11025 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
Where do we use mapping variables in informatica?
wf dont have integration severances how you can run?
When do you use sql override in a lookup transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How do you load only null records into target? Explain through mapping flow.
Enterprise data warehouse your projects phase by phase explain?
What are the differences between oltp and olap?
Define Pmrep command?
What are the guidelines to be followed while using union transformation?
Different qualification between a related rotate toward the sky and isolates look upward?
Write the prerequisite tasks to achieve the session partition?
What is Index Caches size?
Difference between Target-based loading and constraint-based loading?
What are the designer tools for creating transformations?
Explain Dataware house architecture .how data flow from intial to end?
