SSIS Tutorial Part 56-Does Lookup Transformation perform Left Outer Join or Not in SSIS Package
Автор: TechBrothersIT
Загружено: 2015-05-21
Просмотров: 14166
SSIS Tutorial Scenario:
We often hear from developers that we can perform Left Outer Join by using Lookup Transformation instead of using Merge Join.
In this video we will learn if that is possible or not?
Items we will learn in this video
How to Create Two tables with some Sample Data to perform Left Join in TSQL
How to use two tables to perform Left Join by using Merge Join Transformation
How to use Lookup Ignore Failure feature to ignore errors if source record does not match with lookup reference data.
Analyize the output of TSQL Code output, Merge Join output and Lookup Output to see if all three produce same results?
Link to the blog post for this video with script if used
http://sqlage.blogspot.com/2015/05/do...
Check out our Full Step by Step SQL Server Integration Services(SSIS) Tutorial
http://www.techbrothersit.com/2014/12...
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
