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
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
What is the difference between Active and Passive transformation?
Can we create a Integration service without a Repository service and vice versa?
Difference between Data and Index Caches?
Where is metadata stored?
Describe the impact of several join conditions and join order in a joiner transformation?
scenario where i can use only concurrent execution of workflow.
Define the various join types of joiner transformation?
What are the components of Informatica? And what is the purpose of each?
how to load rows into fact table in data warehouse
Which are the different editions of informatica powercenter that are available?
What are the different components of powercenter?
How to create or import flat file definition in to the warehouse designer?
can anyone explain me about retail domain project in informatica?
How to extract sap data using informatica?
What do you mean by blocking transformation?