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 / moorthy g

Source-SQ-Exp-Rtr-Tgt(twice)
Exp:
Flag: DECODE(True, gender='MALE', 'Y','N')
RTR:
Make It Two Group
Flag value is Y then Male is one group.
Defaull is Female

Tgt:
Make It Two;
male - Tgt1
female - Tgt2
=================

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1614


Implementation methodology

1694


What is workflow? What are the components of workflow manager?

1155


What is aggregator transformation in informatica?

924


What is workflow? What are the components of the workflow manager?

1100


What is main use of mapplet?

1119


What is pmcmd command?

1086


Did u used latest transformations of 8.6.0? for what?

1868


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2043


Where do we use mapping variables in informatica?

1042


What do you mean by channel change?

1021


What are the types of schemas we have in data warehouse.

944


Explain how to import oracle sequence into informatica?

985


What is the function of union transformation?

1108


what are the deliverables?in your project?

2127