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
- 10500 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
What is meant by pre and post session shell command?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is incremental aggregation?
How do you migrate data from one environment to another?
Scheduling properties,whats the default (sequential)
What are active transformations.
Explain lookup transformation in informatica
define galaxy repository in informatica
What is the difference between Active and Passive transformation?
Differentiate between a database and data warehouse?
What is a dimensional model?
Explain the 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
Explain pushdown optimization $pushdownconfig parameter - informatica
lookup transformation with screenshots
