I have a new file of 50K profiles which needs to be imported in to ACS. I get an error trying to import these profiles due to gender code.
Gender Code on my file : 'F','M' etc.
Error received:
WKF-560065 the type of the 'GNDR_CD' expression (type: string) does not match the type of the '@gender' destination field (type: byte)
1) When I change the data type to Integer, the data does not get updated in profiles though the worflow runs without any errors. How do I resolve this?
2) The Birth_DT field also does not get mapped into the newly imported profiles. I have changed the format in the load file stage to date which matches the target dimension data type but still does not get imported. How do I import Birth Date?
Thank you!