How to ONLY update attributes in entity, not inserting new members.

Question

Hi,

I would like to find a possibility to update an entity without inserting new members (codes). Just update current codes.

At the moment we have two sources. First source we use to create new members with few attributes, rest attributes of specific meber(for one code) should be updated from the second source. Unfotunately in the second source exists a lot of garbage data, so we do not want to insert them in the entity. That is why we want to update only those members from the first source.

How can I manage this situation?

Thanks in advance,

Łukasz Chalecki

Answer 1

There is not an import type or anything like that you can use.  You should create a simple MDS subscription view from your entity.  During your process to load your staging tables, link to this view.  This will ensure that you only populate/modify codes that already exist in your entity.