Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How do you update the records with or without using update strategy?

1164


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?

2030


Design time, run time. If you don't create parameter what will happen

1893


How to start a workflow using pmcmd command?

1307


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10729


what is mean by complex business rule ?

2220


What are the new features of informatica 9.x in developer level?

1052


what is $$$$?

2204


without table how to come first record only in oracle?

2304


Write the prerequisite tasks to achieve the session partition?

1230


Explain about Informatica server process that how it works relates to mapping variables?

1128


What are the static cache and dynamic cache in informatica?

1245


What are active transformations.

1704


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1250


What is meant by active and passive transformation?

1194