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
- 11042 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 dynamic target flat file name generation in informatica
What is complex mapping?
What is a rank transform?
Explain Dataware house architecture .how data flow from intial to end?
How identifying bottlenecks in various components of informatica and resolving them?
What will be the approach?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain constraint based loading in informatica
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How to do unit testing in informatica? How to load data in informatica ?
What are the advantages of informatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is a sequence generator transformation?
What is data transformation manager process?
