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?
- 4 Answers
- 8506 Views
- TCS, I also Faced
- E-Mail Answers
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
How can we store previous session logs?
How can a transformation be made reusable?
What are the measure objects?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Where is metadata stored?
What do think which one is the better joiner or look up?
list out all the transformations which use cache?
What are the different versions of informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How to go to the older version for a mapping?
Have you worked with/created Parameter file
Explain the types of transformations?
What are some examples of informatica etl programs?
what is informatica metadata?
