You want to derive the gender from a firstname, how would you do this?
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.
Correct Answer:
Verified
Q2: What types of profiling can be performed
Q3: A customer wants to be able to
Q4: Users would export DQ mappings to PowerCenter
Q5: Accelerators provide which of the following?
A)
Q6: When importing a flat file into a
Q7: When applying a reference table in the
Q8: Which is the best combination of functions
Q9: When sharing Projects across teams which of
Q10: Should data be standardized before it reaches
Q11: Which of the following is not true
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents