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
- 9065 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / redflower
src->sq->exp->router->trg1
->trg2
create one variable port and write the substr() function
ename like k% is goes to one trg and remaining records goes
to another trg by using router t/r
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Define sessions in informatica etl?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is the use of target designer?
How do you load alternate records into different tables through mapping flow?
Explain lookup transformation is active in informatica
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How to generate sequence numbers without using the sequence generator transformation?
What are the limitations of joiner transformation?
Where are the source flat files kept before running the session?
What is aggregator transformation in informatica?
what are 3 tech challenges/ common issues you face?
How many input parameters can exist in an unconnected lookup?
Define Pmrep command?
What is a difference between complete, stop and abort?
What is an unconnected transformation?
