34 Union All Transformation in SSIS

preview_player
Показать описание
To watch this video in increased audio volume, please click below link

union all transformation in ssis
What is the difference between Merge and UNION All transformation in SSIS?
What is UNION All transformation?
Is there a UNION in SSIS?
Which is faster UNION or UNION all?

Happy Learning.

Рекомендации по теме
Комментарии
Автор

Hi Aqil, your knowledge is really amazing and the way you are explain its really awesome.

amitsrivastava
Автор

Hi Aqil, could you please suggest if possible. if i have 5 flat file and each has different different data like one fact table and dimensional table and want to merge all these into one flat file, is it possible to merge.

amitsrivastava
Автор

Is it drop duplicates? Thank you for your useful video❤

sheetslibrary
Автор

Is there any way you can improve the audio? Sounds very distant with a lot of echo.

Greg-McIver
Автор

What if the number of columns on excel file is different and also if lets say gender column data type is different in excel
For a union to work we must make sure columns in both sources are mapped i dint see youndoing that how..?

rohitnath
Автор

Hi Bro, thanks for the video. is there a way to get 2 tags from xml source and load the parent and child(4extra record with different tag name in xml file) to same table.

RFocus