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
- 9067 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sivakumar
SQ-->EXP-->ROUTER-->TRg
EMPID
IN_EMPID
in exp t/r
create variable port v_flag in that write the following condition
IIF(EMPID = IN_EMPID ,'1','0')
in router develop 2 conditions for v_flag
the values in the true will b directed to one output which we get the duplicated values
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How can you define user defied event?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to generate sequence numbers?
How to handle decimal places while importing a flatfile into informatica?
How do you migrate data from one environment to another?
What is InformaticaPowerCenter?
waht type of interface is used for testing the data in informatica
expain about the tune parameters?
What is an aggregator transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
What are the types of schemas we have in data warehouse and what are the difference between them?
How to join three sources using joiner?
How does a rank transform differ from aggregator transform functions max and min?
What is source qualifier transformation in informatica?
Is it possible to create multiple domains on a single Informatica server?
