54. Exists Transformation in Mapping Data Flow in Azure Data Factory

[@anusha8129]

thankyou sir

[@subhaoviya]

are we able to compare subset of 2 tables data with this?

[@robinson03584]

HI @WafaStudies, 1.what is the primary difference between 1. exists vs inner join 2.not exists vs left outer join 3.using the Data-Flow LookUp with matched/unmatched rows. the above requirement can be satisfied by all 3 ways right? 2.which one has more performance impact..these are synchronous or asynchronous transformations.?

[@gian-lucahardmeier2806]

to address the first and second question: I believe the process behind inner join and exists is the same but differs in the ouput. While inner join shows the columns/ attributes of both tables (because your goal is to extend the current information content of your rows), exists only shows the data of the left table that exist in the right one