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
- 8571 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
Performance tuning in UNIX for informatica mappings?
What is flashback table ? Advance thanks
How to create a non-reusable instance of reusable transformations?
lookup transformation with screenshots
Explain incremental aggregation in informatica
Explain the scenario which compels informatica server to reject files?
Explain why we use partitioning the session in informatica?
generate date / time dimension in informatica
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Scheduling properties,whats the default (sequential)
What does “tail –f” command do and what is its use as an Informatica admin.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Tell me about MD5 functions in informatica
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the mapping parameters and mapping variables?
