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)

where to select code page option?

2 Answers   TCS,

hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers  

Can you create a flatfile target

3 Answers   ABC,

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

0 Answers  

How to recover sessions in concurrent batches?

3 Answers  

What is the Difference between DSS & OLTP?

5 Answers  

What is rank transform?

0 Answers  

If the records doesnt satisfy the filter condition where will it go?

10 Answers   IBM,

scd methodology?

2 Answers  

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

5 Answers   TCS,

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers