How will you display "Mr" for male & "Mrs" for female in
target table?
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 |
What is operational data source (ODS)?
how can import the data from the flat files?
what is dimension table?
What is a poling?
Differentiate between reusable transformation and mapplet.
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
What are connected or unconnected transformations?
How the dimensions will be loaded?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
Tell me about Propagate functions in informatica