Interested to Buy Any Domain ? << Click Here >> for more details...
How will you display "Mr" for male & "Mrs" for female in
target table?
- 7 Answers
- 12660 Views
- I also Faced
- E-Mail Answers
Answer Posted / deepthi
Here the question is to just display value 'MR'for
males 'MR'for males , not to modify the data in the table
as 'MR'for males 'MR'for males
we can do it by many ways, one among those ........
select decode(column_name, 'male','MR','female','MRS')
this query displays MR for all males and MRS for all females
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
Can informatica load heterogeneous targets from heterogeneous sources?
What is transformation?
What is rank transformation?
What are the performance considerations when working with aggregator transformation?
How to load data in informatica ?
What is sequence generator transformation in informatica?
How you prepared reports for OLAP?
Describe the impact of several join conditions and join order in a joiner transformation?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Why update strategy and union transformations are active?
What is a difference between complete, stop and abort?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is Cognos script editor?
What is the use of code page?
What is rank index in rank transformation?
