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
- 10789 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
How to load data in informatica ?
What are the transformations that are not supported in mapplet?
What are the settings that you use to configure the joiner transformation?
What is the session task and command task?
What is transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
design of staging area?
Why do you use Mapping Parameter and mapping variable?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a transaction control transformation?
What are the reusable transformations?
What are the restrictions of union transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Where are the source flat files kept before running the session?
What are the different clients of powercenter?
