DataMerger Activity

[Arindam Bhattacharyya 2]

Can somebody please explain to me how does the DataMerger activity actually work As per the documentation, "The Data Merger activity performs the insert, update, and delete operations on the parent-child table". My understanding is if child table is joined toparent table, then whatever we insert into parent table will be inserted into child table.

But whenI inserted 1 row into a parent table and though there was a primary key and a "join to" was also configured in the adb schema, the row was not inserted into the child schema. Also if separate datas are mapped to parent table and child table, there is no error and separate datas are getting inserted into the respective tables.