How to load data to lookup table in dynamics

Sushmitha 1 Reputation point


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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,778 questions
{count} votes