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

What is operational data source (ODS)?

7 Answers  


how can import the data from the flat files?

2 Answers  


what is dimension table?

17 Answers  


What is a poling?

2 Answers  


Differentiate between reusable transformation and mapplet.

0 Answers  






There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

7 Answers   IBM,


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,


IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,


What are connected or unconnected transformations?

0 Answers   Informatica,


How the dimensions will be loaded?

0 Answers   HCL,


get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,


Tell me about Propagate functions in informatica

0 Answers  


Categories