How will you display "Mr" for male & "Mrs" for female in
target table?
Answers were Sorted based on User's Feedback
Answer / giri
Use Expression Transformation
Add new Field
Condition
IIf(fieldname='male','Mr','Mis')
This field Check Variable then
add newfield Concat(newfield,first name)
Is This Answer Correct ? | 9 Yes | 0 No |
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 |
Answer / rkumar.etl
based on flag for male and female we can use decode logic at
expression level before loading records to the target tables.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / dragon
I agree with Rkumar.etl,
but if in the database is too old and they dont have column
flag then how you u define.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / addy
This can be done by the Expression Transformation easily.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / narinder
Assuming that the source data has some kind of identifier
to track male or female record then use the decode function
based on idetifier to store 'Mr' or 'Mrs' in a port in an
expression transformation and pass this port value to
target.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / madhusudhana reddy
decode(gender,male,'Mr',Female,'Mrs,optional)
Is This Answer Correct ? | 1 Yes | 1 No |
How to list Top 10 salary, without using Rank Transmission?
Diff b/w ShortCut and reusabel Object ?
What is junk dimention?
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
how do u fnd the duplicate rows and how to delete the duplicate rows?
when we use dynamic lookup,if condition matches what will be the o/p?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
where to store informatica rejected data?
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
What is the procedure for creating independent data marts from informatica 7.1?