Much needed content Aqil. Thank you for making this.
@learnssis2 жыл бұрын
You are most welcome Piravi Perumal.
@notoriousft2 жыл бұрын
Very useful as always.
@learnssis2 жыл бұрын
You are most welcome.
@sureshareti28432 жыл бұрын
Excellent bhaiyya..
@learnssis2 жыл бұрын
Thank you Suresh.
@special5b82 жыл бұрын
Its very helpful bro thank you so much
@learnssis2 жыл бұрын
You are welcome Vishnu.
@Karenshow Жыл бұрын
Thanks so much for your help.
@learnssis Жыл бұрын
You are most welcome.
@techbroaniletl82262 жыл бұрын
Thank You bro. I am waiting for your Vidos egarly
@learnssis2 жыл бұрын
Thank you Sai Kumar.
@faibichandrei31893 ай бұрын
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.
@learnssis3 ай бұрын
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.
@arimbakammeghavardhan64242 жыл бұрын
Very very useful video. Hi aquil please can you make video on unit test of packages......
@learnssis2 жыл бұрын
Hi Arimbakam, we have one video on the unit test below kzbin.info/www/bejne/aKrblIRja6-YbbM I will try to make second part of this video.
@arimbakammeghavardhan64242 жыл бұрын
Thanks bro
@7to7media2 жыл бұрын
tq
@learnssis2 жыл бұрын
You are most welcome.
@techbroaniletl82262 жыл бұрын
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).
@learnssis2 жыл бұрын
Here you go kzbin.info/www/bejne/f5PMlnd3ltmZa68
@nareshyadalaАй бұрын
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
@learnssisАй бұрын
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
@nareshyadalaАй бұрын
@@learnssis 2.stmt for update statmt creating indexes is slow down the performance
@AlbertoLogs Жыл бұрын
Why are there pictures of women in your thumbnails?
@learnssis Жыл бұрын
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.
@techbroaniletl82262 жыл бұрын
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).