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)

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

what is the difference between repository & Intergration service

1 Answers  

What are ETL Tools?

0 Answers   Informatica,

What do you mean by filter transformation?

0 Answers  

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

15 Answers   Deloitte,

What is the difference between Active and Passive transformation?

0 Answers   Informatica,

Can you copy the batches?

3 Answers  

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,