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 / annu

select decode(gender,'female',name) FEMALE,
decode(gender,'male',name) MALE from src;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how to import oracle sequence into informatica?

1071


generate date / time dimension in informatica

1164


What is decode in static cache?

1264


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2187


In informatics server which files are created during the session rums?

1169


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2325


What are mapplets? How is it different from a Reusable Transformation?

1137


explain one complex mapping with logic? sales project?

6738


server hot-ws270 is connect to Repository B. What does it mean?

2654


what are 3 tech challenges/ common issues you face?

2397


What all are steps in up gradation of Informatica server?

1096


What is blocking transformation?

1189


How to load a Dimension ? and how to load a fact table?

1465


What is sq transformation?

1233


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

2057