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
- 8314 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
difference between repository database and repository service?
Differentiate between a database and data warehouse?
Mention few advantages of router transformation over filter transformation.
When do you use sql override in a lookup transformation?
How can we create index after completion of load process?
Explain about Informatica server process that how it works relates to mapping variables?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain lookup transformation is active in informatica
Explain the pipeline partition with real time example?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Define Pmrep command?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the reusable transformations?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How can we handle two sessions in informatica?
