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
- 9064 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ramesh
target1
SQ->Router->
target2
1.In router create one group and specity
the condition empid=201 or empid=202.
2.It is connected to target1.
3.Default group is connected to target2.
Thanks & Regards
Ramesh
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
How to extract sap data using informatica?
How to update source definition?
What are the main features of Oracle 8i with context to datawarehouse?
What is pmcmd command?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How many number of sessions can one group in batches?
Explain lookup transformation is active in informatica
What is Index Caches size?
What differs when we choose the sorted input for aggregator transformation?
What is meant by lookup transformation?
Whats there in global repository
how to create user defined function (udf) in informatica
Explain transaction control transformation in informatica
difference between repository database and repository service?
How to do unit testing in informatica? How to load data in informatica ?
