56. Lookup Transformation in Mapping Data Flow in Azure Data Factory

[@VarunKumar-xt4jq]

Crystal clear explanation...Good work, keep it up!

[@Supi0312]

If this is same as left outer join then what is diff between join and lookup?

[@amarnadhgunakala2901]

Thanks for video, i Have a doubt , if Lookup transformation is similar to left outer join why don't we use join transformation with left outer join?? Whats differene?

[@WafaStudies]

To be frank even I have this question. I feel may be to make developer life easy. But still let do some research on it and get back to you

[@MSDataFactory]

Lookup includes the ability to match on single row or all rows that match your lookup condition. If you use Join, you will need to Sort and Aggregate later to achieve this. That is all handled for you under "Match On" in the Lookup transformation UI.

[@manniedigicast]

This is an amazing video. 😎 I would like to know if it is possible to use this same approach of the department table was coming from a REST API. How would I approach such scenario?

[@WafaStudies]

Yes I guess u can use JSON type dataset also. Kindly try it may work

[@hindi-english1664]

how can we prevent the free trial credit of Azure to deduct?

[@tanushreenagar3116]

Too nice thnk u

[@vizureddy6706]

how can we filter non matching records after the lookup transformation

[@gouravkarmakar9606]

just apply filter and in the expression write !isnull(column name)

[@kolaramakrishna8081]

hi sir, i am getting column name as column1,column2, column3....tell me how to get the column names as deptid, empname like that....i am using sandbox and thought this is the reason of getting this probkem.

[@Anupba-h1g]

while adding the dataset set, select first row as header and Import schema is from connection store and when we got to sink while adding new dataset select import schema as None