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 / vicky
select name as male from table where gender= 'male'
union select name as female from table where gender='female'
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is target designer and target load order?
How is union transformation utilized?
Write the different tools in the workflow manager?
What is update strategy transform?
What is confirmed fact in dataware housing?
What is sorter transformation?
Explain dynamic target flat file name generation in informatica
How does a rank transform differ from aggregator transform functions max and min?
What are the differences between source qualifier and joiner transformation?
Separate from a database, an information bazaar, and an information stockroom?
What are the measure objects?
tell me 5 session failure in real time how can you solve that in your project?
Can we override a native sql query within informatica?
Explain how many types of dimensions are available in informatica?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?