Field mappings when bulk loading entities using other entities RRS feed

  • Question

  • Hi. I have the following setup. There is an entity called Store and another one called SourceStore. They do have the same structure (fields). I want to grab a bunch of SourceStores and insert them into Store. But I'm doing this using the standard MDS staging table, stg.Store_Leaf. Now, I have a problem of the following kind. There are some fields that are domain-constrained in both entities (obviously). The view mdm.SourceStore, for instance, has fields called: Brand_Code, Brand_ID and Brand_Name. But the staging table only has a field called Brand. The question is: Which of the three fields from the SourceStore should be mapped to Brand if Brand is domain-constrained?


    Wednesday, June 22, 2016 10:25 AM