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
- 13126 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
Explain incremental aggregation in informatica
What is deployment group?
What is transformation?
how many types of dimensions are available in informatica?
difference between repository database and repository service?
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 is a predefined event?
What are the different types of transformation available in informatica.
Is it possible to create multiple domains on a single Informatica server?
To import the flat file definition into the designer where should the flat file be placed?
how we can load rejected record's at run time?(not through bad files)
Explain about Informatica server process that how it works relates to mapping variables?
What are the uses of etl tools?
what is Active lock explain
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
