Hi @czgaraga 

You can add a mapping to another table by simply dragging and dropping the table from the data source in the ODX data source on top of the DW table. Please let me know if this answers your question

Hi Christian,

Thanks for your quick reply :-)

Here is  a screen shot of what I mean :

Is it possible to do that in TX ?

Should we clean the id in the sources before loading it in TX ?

What would be the best practice/strategy ?

Thanks again!

Christine

Hi @czgaraga 

If you only want to merge the name, you should do it like so.

When you map a field and use the right mouse button, you will get this option.

If you use the middle option, it will share the Name field and the others will be created as individual fields.

It will essentially give a similar look to what you want.

Thanks a lot ! will try it!

Dear @czgaraga ,

The screenshot looks a lot like a kind of full outer join and then keep only the unique values. something like that could be created in a view. Load all 3 tables in the DSA and create a view on top of that.

If you want to create one conformed dimension you could use the options that @Christian Hauggaard  and @Thomas Lind  suggest. but, if you have the same key in multiple systems, this could create an issue on either duplicate Primakry Keys or issues in the Data model (many to many relation)

In that case I would use the ‘add related records’ option. You can find a step by step how to here: 
 

Hope this helps
= Daniel​​​​​​​

Hi @czgaraga 

Maybe the following solution will work for you. As Daniel suggested you can use a custom view

First I load the data into a table with multiple mappings

Then I add the source table field

Then I add a custom view

Wow thanks a lot for all your answers!!!!  I should be able to try it next week so will let you know how it goes :-)

Thanks again!

Christine