following source
name gender
ramya female
ram male
deesha female
david male
kumar male
i want the target
male female
ram ramya
david deesha
kumar
any body give solution above question?
Answer Posted / voma
use router transformation, In that 2 groups
1 is male, 2 is female,
target is single, but we drag the table twice
In that router 1st group condition
select * from table where gender='male'
2nd group condition
select * from table where gender='female'
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do you update the records with or without using update strategy?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Design time, run time. If you don't create parameter what will happen
How to start a workflow using pmcmd command?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
what is mean by complex business rule ?
What are the new features of informatica 9.x in developer level?
what is $$$$?
without table how to come first record only in oracle?
Write the prerequisite tasks to achieve the session partition?
Explain about Informatica server process that how it works relates to mapping variables?
What are the static cache and dynamic cache in informatica?
What are active transformations.
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is meant by active and passive transformation?