118 Merge join transformation in SSIS with example

[@nitishgalat5483]

Your explanation skills are great!!!

[@chandraprakashnaidu9009]

Thank you for your video sir..it's crystal Clear explanation, anyone can learn and clear doubts easily by watching your videos

[@learnssis]

You are most welcome Chandra Prakash Naidu.

[@CaribouDataScience]

Ok, I am trying to follow this video, but after the sort (CALL_DATE) followed by the Merge I keep , "Both transformations must contain at least on sorted column"? The problem both imputs have a sort function?

[@learnssis]

If you are using Sort transformation then ideally it should work.

[@ereshadul]

What if second table do not have any extra column, in this case no country column?

[@learnssis]

Correct.

[@WayToWisdom15]

Plz create vedio on informatica power center

[@learnssis]

Hi, Unfortunately I never get a chance to work on Infomatica power center thus don't know if I will be able to make videos on this one.

[@shaikaniph4125]

Hi sir, I am watching all videos of your SSIS related, those videos are full of useful in real time work environments. I have one doubt on it . Matched data is going to one table and unmatched data going to another table. In the same scenario how do we maintain SCD type 2 means to keep history of the data and need to update matched data as new record and insert as new record as unmatched data.

[@learnssis]

Thanks for watching my videos, I have created a video in past of handling SCD Type 2 but using Slowly changing dimension and using one more method kzbin.info/www/bejne/m4XQcqGVqMqnfKs Now I am thinking to make a video using Lookup transformation of maintaining the SCD Type 2 records.

[@shaikaniph4125]

Thanks sir