How will you display "Mr" for male & "Mrs" for female in
target table?

Answers were Sorted based on User's Feedback



How will you display "Mr" for male & "Mrs" for female in target table?..

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

How will you display "Mr" for male & "Mrs" for female in target table?..

Answer / 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

How will you display "Mr" for male & "Mrs" for female in target table?..

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

How will you display "Mr" for male & "Mrs" for female in target table?..

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

How will you display "Mr" for male & "Mrs" for female in target table?..

Answer / addy

This can be done by the Expression Transformation easily.

Is This Answer Correct ?    0 Yes 0 No

How will you display "Mr" for male & "Mrs" for female in target table?..

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

How will you display "Mr" for male & "Mrs" for female in target table?..

Answer / madhusudhana reddy

decode(gender,male,'Mr',Female,'Mrs,optional)

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,


Diff b/w ShortCut and reusabel Object ?

4 Answers  


What is junk dimention?

3 Answers   Patni,


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!

2 Answers  






how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,


when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,


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

0 Answers  


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?

5 Answers   Patni,


where to store informatica rejected data?

0 Answers  


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

3 Answers   IBM,


What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  


Categories