如何使用 adf 将数据加载到 Dynamics 365 交叉点/桥梁表
我有两个实体人和位置，它们之间在动态中具有多对多关系，有一个名为 person_location 的桥接表/交集表，它具有人员和位置表的唯一 ID（人员 id 和位置 id 列 GUID）。由于无法在动态中为桥接表定义备用键列（无法修改）。我无法使用 adf 复制活动执行此操作，因为它仅支持 upsert 操作和要在动态中定义的键列。您能告诉我如何使用 adf 中的数据流任务将数据加载到此桥接表吗
I have two entities person and location which has many to many relationship between them in dynamics there is bridge table /intersection table called person_location that has unique id of both person and location table(person id and location id column-guid). As it is not possible to define alternate key column in dynamics for bridge table(it can't be modified).. I cannot do this using adf copy activity as it supports only upsert operation and a key column to be defined in dynamics..can you please tell me how to load data to this bridge table using dataflow task in adf
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
ADF 复制活动不支持多对多关系。
https://learn.microsoft.com/en-us/answers/questions/384308/how-to-associate-two-dynamics-365-custom-entities.html
Many-to-Many relationships are not supported by ADF Copy Activity.
https://learn.microsoft.com/en-us/answers/questions/384308/how-to-associate-two-dynamics-365-custom-entities.html