I watched the video very attentively snd saw how u mentioned the duplication issues that happen with different joins. Also throughout the video I saw you mention that it will require some homework to solve this duplication issue, but you never mentioned what is the solution and what homework are you talking about to resolve these issues
Lookups are simple and fast ways of adding columns from another dataset based on a common key. They preserve the original grain of the data and return only one matching value per row. However, they cannot handle multiple matches or non-matches. Inner joins are more flexible and powerful ways of merging datasets based on one or more conditions. They can handle multiple matches and non-matches.
This video is very important to watch and understand prior to start with dataflow and Recipes
also provide the training files link and all the playlist in Description or commenct section
I watched the video very attentively snd saw how u mentioned the duplication issues that happen with different joins. Also throughout the video I saw you mention that it will require some homework to solve this duplication issue, but you never mentioned what is the solution and what homework are you talking about to resolve these issues
I know there is a difference between the lookup and the inner join, but I am not quite seeing it. What is it? Thanks!
Lookups are simple and fast ways of adding columns from another dataset based on a common key. They preserve the original grain of the data and return only one matching value per row. However, they cannot handle multiple matches or non-matches.
Inner joins are more flexible and powerful ways of merging datasets based on one or more conditions. They can handle multiple matches and non-matches.