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)

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

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.

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.

Answer / addy

This can be done by the Expression Transformation easily.

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.

Answer / madhusudhana reddy

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

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,

what is the size of your data warehousing?

0 Answers   IBM,

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

without using rank transformation how can we rank items by using some other transformations

2 Answers  

What are the tasks that source qualifier performs?

1 Answers  

How to Create a folder using pmrep command?

0 Answers  

scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,

How big was your fact table

0 Answers  

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers