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 / krishna
select * from (select distinct name male from fm where
gender='male'),(select distinct name female from fm e
where gender='female');
select decode(gender,'female',name)female,decode
(gender,'male',name)male from fm ;
Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How do you update the records with or without using update strategy?
What are the popular informatica products?
How can we use batches?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is dimensional table? Explain the different dimensions.
What are the different types of repositories created using informatica?
What is fact table? Explain the different kinds of facts.
How we can create indexes after completing the loan process?
What is the cumulative sum and moving sum?
What is event and what are the tasks related to it?
What is the session task and command task?
What is meant by pre and post session shell command?