A) Use a reference table with the firstname as the valid column and the gender in the second column. Then choose to Replace Reference Table Matches with Valid Values when applying the reference table in a strategy in the Standardizer. Use the firstname as input.
B) Use a reference table with the gender as the valid column and the firstname in next column. Then choose to Replace Reference Table Matches with Valid Values when applying the reference table in a strategy in the Standardizer. Use the firstname as input.
C) Use a decision and create an If then else rule eg: If fname = 'Jennifer' then gender: = 'F' Endif
D) Then choose to Replace Reference Table Matches with Custom Strings when applying the reference table in a strategy in the Standardizer. Use the firstname as input.
10+ million students use Quizplus to study and prepare for their homework, quizzes and exams through 20m+ questions in 300k quizzes.
Explore our library and get Informatica Homework Help with various study sets and a huge amount of quizzes and questions
Find all the solutions to your textbooks, reveal answers you would’t find elsewhere
Scan any paper and upload it to find exam solutions and many more