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
- 10777 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
Explain what are the different versions of informatica?
what is the size of u r source(like file or table)?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is domain in terms of informatica?
What is DR strategy for Informatica project?
how tokens will generate?
What are the tasks that source qualifier perform?
What is decode in informatica?
What are the performance considerations when working with aggregator transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
To import the flat file definition into the designer where should the flat file be placed?
What is joiner transformation in informatica?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How to delete duplicate row using informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
