Hi Aqil! Could you please explain the idea behind your third point in more details. What about data in the target table which is not supposed to be updated? As I understand, Left Join will lead to loss of this data as it is absent in the stage table. It will be replaced by NULLs.
In third point I am not saying to use the left join, you can use inner join and create the new table from 2 or more tables. The idea is if you need to update a lot data the, join 2 tables together and create a new table.
Hi bro good stuff for us, Please can you make one of the videos regarding (the moving file was one folder to another folder (Archive) with the help of the file system task).
I was searchig for performance tunning vedios i found this ,i am not clear abut 2&3 points (2.if we create indexes on joins columns in the update will it impact performance,3.creating a new table in place of update for huge data loads),please ellobrate more or create one more vedio to understand better
2. If have indexes on a table then it makes insert\delete\update run slower. 3. If you have a large table and you need to update a lot of columns, then instead of updating the data from one table to another, use a select query and join the tables together, now select the required columns from both the tables, like all non update columns from left table and the columns to be updated from right table and create a new table. Creating a new table will be faster as compare to updating so many columns in a table when data is huge and specially if you have indexes on the table. select a.column1, a.column2, b.column3, b.column4 into newtable from table1 a inner join table2 b on a.id = b.id
Actually I have a license from canva to create the thumbnails, and there are tons of pre created templates there where we can add our own customized text and image. For majority of thumbnails I have only put my text and left the image as it is, may be I can think of adding my own picture to the thumbnail.
Hi bro good stuff for us, Please can you make one of the videos regarding (the moving file was one folder to another folder (Archive) with the help of the file system task).
Much needed content Aqil. Thank you for making this.
You are most welcome Piravi Perumal.
Hi Aqil! Could you please explain the idea behind your third point in more details. What about data in the target table which is not supposed to be updated? As I understand, Left Join will lead to loss of this data as it is absent in the stage table. It will be replaced by NULLs.
In third point I am not saying to use the left join, you can use inner join and create the new table from 2 or more tables. The idea is if you need to update a lot data the, join 2 tables together and create a new table.
Excellent bhaiyya..
Thank you Suresh.
Its very helpful bro thank you so much
You are welcome Vishnu.
Thank You bro.
I am waiting for your Vidos egarly
Thank you Sai Kumar.
Very very useful video. Hi aquil please can you make video on unit test of packages......
Hi Arimbakam,
we have one video on the unit test below
ruclips.net/video/2yxcQ-6Je7Q/видео.html
I will try to make second part of this video.
Thanks bro
Hi bro good stuff for us, Please can you make one of the videos regarding (the moving file was one folder to another folder (Archive) with the help of the file system task).
Very useful as always.
You are most welcome.
Thanks so much for your help.
You are most welcome.
I was searchig for performance tunning vedios i found this ,i am not clear abut 2&3 points (2.if we create indexes on joins columns in the update will it impact performance,3.creating a new table in place of update for huge data loads),please ellobrate more or create one more vedio to understand better
2. If have indexes on a table then it makes insert\delete\update run slower.
3. If you have a large table and you need to update a lot of columns, then instead of updating the data from one table to another, use a select query and join the tables together, now select the required columns from both the tables, like all non update columns from left table and the columns to be updated from right table and create a new table. Creating a new table will be faster as compare to updating so many columns in a table when data is huge and specially if you have indexes on the table.
select a.column1, a.column2, b.column3, b.column4 into newtable from table1 a inner join table2 b on a.id = b.id
@@learnssis 2.stmt for update statmt creating indexes is slow down the performance
tq
You are most welcome.
Why are there pictures of women in your thumbnails?
Actually I have a license from canva to create the thumbnails, and there are tons of pre created templates there where we can add our own customized text and image. For majority of thumbnails I have only put my text and left the image as it is, may be I can think of adding my own picture to the thumbnail.
Hi bro good stuff for us, Please can you make one of the videos regarding (the moving file was one folder to another folder (Archive) with the help of the file system task).
Here you go
ruclips.net/video/IbieDAatf5M/видео.html