That City 'Salt Lake City', country 'USA' entry 😂😂 I'm from kolkata .. btw thanks for this masterpiece playlist for SSIS. I am following this and learned a lot. Thanks Brother ✨
@@learnssis thanks. I have gone through all of your ssis interview videos. Is there any document refference to clear ssis related interview. I have total 7 years experience. Mostly worked on supporting stuff. Didn't have much practical experience. So going through your videos and practicing
Actually yesterday I got complaint about the low volume of the video and I noticed because this is summer season and if some one is watching the video in fan sound without earphone\headphone then it will be hard for him to hear the volume, thus I increased the volume of the video and reuploaded it and removed the old video from ssis tutorial playlist. You can check the audio difference in both the videos Old video th-cam.com/video/7SmF7MhcWhc/w-d-xo.html&lc=UgxpOi_cAVDyWQAgzRx4AaABAg New Video th-cam.com/video/3QPwy4g1chE/w-d-xo.html
@@notoriousft No problem, I had also disabled the notification for this new video, so that existing subscribers should not get a notification for this, not sure how you got it :)
Hi Aqil, good day. Lets say I have 20 million of record in main table(sql)...I use lookup for update or insert the record(incremental update). Is the lookup take very long time to check between temporary table and main table based on primary key?main table and temporary table residing in same server. I waited more than 3 hours but still not finished processed 🥲
Yeah according to data it can take time. Try to use a select query inside Lookup transformation just to select the columns those are needed in the join, don't select the whole table. Also try to create the indexes on joining table between temporary and main table.
![เปิดบ้าน โคตรสวย ป๋องกพล รู้จักตั้งนาน เพิ่งรู้ว่ารวย!!! l [Nickynachat]](http://i.ytimg.com/vi/tmgCF_2HfYI/mqdefault.jpg)
![ILLSLICK X YOUNGOHM - We're The same [Official Video]](http://i.ytimg.com/vi/yUJNkobYR0E/mqdefault.jpg)
That City 'Salt Lake City', country 'USA' entry 😂😂 I'm from kolkata .. btw thanks for this masterpiece playlist for SSIS. I am following this and learned a lot. Thanks Brother ✨
Salt Lake City is the capital of Utah state from USA, I have been there, that's why I given that name. Thanks for following the videos.
Great Job! Thank You!
Glad you liked the video.
Nice explanation, If you give real time example how it will used will be more helpful. Just a suggestion . Once again thanks for your hard work..!
Yeah you are right, I have made a more detailed video on this one here
th-cam.com/video/8dRIjVhKoKs/w-d-xo.html
@@learnssis thanks.
I have gone through all of your ssis interview videos. Is there any document refference to clear ssis related interview. I have total 7 years experience. Mostly worked on supporting stuff. Didn't have much practical experience. So going through your videos and practicing
Hi sir, I am a fresher Is there any openings in your company
Hi, at the moment we don't have the opening for freshers.
Why did you reupload the same video from 3 years ago?
Actually yesterday I got complaint about the low volume of the video and I noticed because this is summer season and if some one is watching the video in fan sound without earphone\headphone then it will be hard for him to hear the volume, thus I increased the volume of the video and reuploaded it and removed the old video from ssis tutorial playlist.
You can check the audio difference in both the videos
Old video
th-cam.com/video/7SmF7MhcWhc/w-d-xo.html&lc=UgxpOi_cAVDyWQAgzRx4AaABAg
New Video
th-cam.com/video/3QPwy4g1chE/w-d-xo.html
@@learnssis I hadn't noticed that at first. Thanks for the video.
@@notoriousft No problem, I had also disabled the notification for this new video, so that existing subscribers should not get a notification for this, not sure how you got it :)
Hi Aqil, good day. Lets say I have 20 million of record in main table(sql)...I use lookup for update or insert the record(incremental update). Is the lookup take very long time to check between temporary table and main table based on primary key?main table and temporary table residing in same server. I waited more than 3 hours but still not finished processed 🥲
Yeah according to data it can take time. Try to use a select query inside Lookup transformation just to select the columns those are needed in the join, don't select the whole table. Also try to create the indexes on joining table between temporary and main table.
@@learnssis Okay. Thanks for the help. 😀
@@jaavithnazeem4507 np.