'How to load data to intersection table in dynamics using 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



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source