How will you display "Mr" for male & "Mrs" for female in
target table?
- 7 Answers
- 10717 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Answer / addy
This can be done by the Expression Transformation easily.
| Is This Answer Correct ? | 0 Yes | 0 No |
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 |
Answer / madhusudhana reddy
decode(gender,male,'Mr',Female,'Mrs,optional)
| Is This Answer Correct ? | 1 Yes | 1 No |
how to get the only updated records in the target
What is IQD file?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is a test load?
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
What is operational data source (ODS)?
Can you generate reports in Informatcia?
what is the difference between lookupoveride and joiner?
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500
Design a mapping to load a target table with the following values from the above source?
what is inline view?
Teradata 
