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
- 12945 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
I have a flat file, want to reverse the contents of the flat file
What is sq transformation?
What is enterprise data warehousing?
What are the different transaction levels available in transaction control transformation?
what is size of u r database?
How to configure mapping in informatica?
Enterprise data warehouse your projects phase by phase explain?
Why do you use Mapping Parameter and mapping variable?
What are the components of Informatica? And what is the purpose of each?
What is a snowflake schema?
Repository user profiles
Which transformation should we use to normalise the COBOL and relational sources?
How to create Target definition for flat files?
What is Data Caches size?
What is deployment group?
