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
- 12977 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
wf dont have integration severances how you can run?
What is the advantage of informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Why update strategy and union transformations are active?
I have a flat file, want to reverse the contents of the flat file
What are the steps involved in the migration from older version to newer version of Informatica Server?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to extract sap data using informatica?
where to store informatica rejected data?
Explain the difference between mapping parameter and mapping variable?
What is the need for an etl tool?
How can you generate reports in informatica?
How to join three sources using joiner? Explain though mapping flow.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Is there any target staging area in informatica not staging area
