In my sourse i have like
ename,gender
vasu,male
geetha,female
ram,male
suma.female
kesav,male
in my output i need
male,female
vasu,geetha
ram,suma
kesav
Answer Posted / srinivas.medagum
When i used SQ..>EXPRESSION T/R...>ROUTER...>UNION...>TRG
I AM GETTING OUTPUT ,BUT NOT IN PROPER LIKE
MALE,FEMALE
VASU
RAM
KESAV
SEETHA
SUMA
CAN I USE TWO TARGETS , HOW CAN GET IN PROPER WAY?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How can you differentiate between powercenter and power map?
What is the difference between stop and abort in informatica
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the settings that you use to configure the joiner transformation?
can anyone suggest best free Talend data integration training online
What are pre and post-session shell commands?
explan ur project architecture?
EXL informatica Questions
Explain the shared cache and re-cache?
What all join we can perform in LOOKUP transformation?
Define Pmrep command?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain transaction control transformation in informatica