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?
- 8 Answers
- 12499 Views
- BRAD, TCS, I also Faced
- E-Mail Answers
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
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How to open an older version of an object in the workspace?
Differentiate between a database and data warehouse?
What is joiner transformation in informatica?
What is complex mapping?
Is stop and abort are same in informatica?
design of staging area?
Explain the types of lookup transformation?
Define sessions in informatica etl?
What are junk dimensions?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are some examples of informatica etl programs?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is session task and command task?
How can we create index after completion of load process?
