Want to add a field from a different table

[ferha_jafri]

Hello Everyone,

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.

this is very urgent.

Thanks in advance

Ferha Jafri

[saimahasan]

are the fields in both the table has same values??

[marcus_sommer]

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.

- Marcus

[kaushiknsolanki]

HI,

Is it possible to share the script with us. So that it becomes easy to understand your issue and find solution to it.

Regards,

Kaushik Solanki