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
Enterprise data warehouse your projects phase by phase explain?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Differentiate between sessions and batches?
What is the need of an ETL tool?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
EXL informatica Questions
What is informatica powercenter repository?
What is informatica? Why do we need it?
How to load a Dimension ? and how to load a fact table?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is the format of informatica objects in a repository?
What is native users?
can anyone explain me about retail domain project in informatica?
What are the uses of etl tools?