I need help in an issue ,the issue is as i want to connect recordtypename field which is present in record type table with record type id with five tables so that name corresponds to recordtype id in those tables so how i can merge two tables ,concatenate is not working i want use mapping but not gettin record name that field is coming as a blank field when i am applying mapping.
I think that you have a small error within your mapping-approach - whereby I'm not sure if you should merge this field to the other tables. Quite probably will the association between the id-field and the dimension-table work very well and merging will cause errors through synthetic keys or some additionally efforts to avoid then without having any added value.
