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

What is the commit type if you have a transaction control transformation in the mapping?

1022


What is the meaning of up gradation of repository?

1961


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1058


what is $$$$?

2134


What do you understand by SOA of Informatica?

967


What do you mean incremental aggregation?

1059


How do we call shell scripts from informatica?

1091


can any one give some examples for pre sql and post sql(Except dropping and creating index).

4097


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1113


Explain pushdown optimization $pushdownconfig parameter - informatica

1118


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1221


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1052


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2003


explan ur project architecture?

2046


Explain the mapping variable usage example in informatica

1137