based on flag for male and female we can use decode logic at expression le

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

Question Posted / rkumar.etl

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

Please Help Members By Posting Answers For Below Questions

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5760

Explain sessions and how many types of sessions are there?

987

what is index?how it can work in informatica

2029

What are the data movement modes in informatica?

1133

Differences between connected and unconnected lookup?

1201

How to create Target definition for flat files?

1197

What are the reusable transformations?

1143

What is an active transformation?

1081

Enlist the tasks for which source qualifier transformation is used.

1022

How do you migrate data from one environment to another?

1080

What are the designer tools for creating transformations?

1100

What is the sequence generator transformation in informatica?

1161

how many types of dimensions are available in informatica?

1070

What is a passive transformation?

1080

Write the unconnected lookup syntax and how to return more than one column.

1097