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
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Explain transaction control transformation in informatica
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
my source is junk data how will u remove that junk data by using unix please any one replay me
How union transformation is used?
How do you handle two sessions in Informatica
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the advantages of informatica?
How to update a particular record in target with out running whole workflow?
What are the types of data warehouses?
What is workflow manager?
Explain the different kinds of facts.
What do you understand by a term domain?
What is the difference between Active and Passive transformation?
Informatica Checkpoints