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
- 12640 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
What's the layout of parameter file (what does a parameter file contain?)?
Differentiate between sessions and batches?
Could you explain what is enterprise data warehouse?
Design time, run time. If you don't create parameter what will happen
Can anyone tell me the new features in Informatica 9 Version?
What are the designer tools for creating transformations?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is incremental aggregation?
What is joiner transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is native users?
my source is junk data how will u remove that junk data by using unix please any one replay me
Explain how many types of dimensions are available in informatica?
What is persistent lookup cache?
Differentiate between source qualifier and filter transformation?
