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
- 10689 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / chiky
sq-->router--target1
|__target2
in router create one group and another default
coundition : decode(empid,201,true,decode
(empid,202,true,false))
connect group one in target table one
connect default in target table two
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Is there any way to read the ms excel datas directly into informatica?
What are junk dimensions?
What is the difference between Active and Passive transformation?
What is joiner transformation?
What is a connected transformation?
What do you mean incremental aggregation?
Explain the difference between mapping parameter and mapping variable?
What are some examples of informatica etl programs?
Explain the mapping variable usage example in informatica
How many input parameters can exist in an unconnected lookup?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
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?
can u give example for factless fact table
What is complex mapping?
