Interested to Buy Any Domain ? << Click Here >> for more details...
How will you display "Mr" for male & "Mrs" for female in
target table?
- 7 Answers
- 12650 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 |
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
What is an aggregator transformation?
why do we go for update strategy tr in SCD rather using the session properties?
How many ways are there to do 'remove duplicate records in informatica'?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
what are the differences between powercenter 8.1 and powercenter 8.5?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
disable caching in a lookup transformation?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
What did you do in source pre load stored procedure
Teradata 
