How will you display "Mr" for male & "Mrs" for female in
target table?
- 7 Answers
- 10597 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
How to do the error handling of if ur source is flatfiles?
What do you mean incremental aggregation?
what is unit testing?tell me proceedure
What is the difference between a repository server and a powerhouse?
Informatica Checkpoints
What is option by which we can run all the sessions in a batch simultaneously?
What is the commit type if you have a transaction control transformation in the mapping?
What is a filter transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Repository user profiles
Under what condition selecting sorted input in aggregator may fail the session?
explain one complex mapping with logic? sales project?
Clarify the utilization of aggregator cache record?
