08 Understanding normalization with example in SQL Server

[@datachainchannel7925]

Thank you for the great video, Aqil sir

[@learnssis]

You are most welcome Data chain Channel.

[@PALLABIDEYDAS]

Hello Aquil Sir - Sorry to bother. Please help. I cannot understand this - At 10:27, how did you get the data in tblSwapDatabases_New table? How to build relationship between the smaller tables and tblSwapDatabases_New so that if we update smaller tables it reflects the same in the New table? Thank you very much for uploading these videos. Very helpful! You're a Guru.

[@learnssis]

In the description of the video, I have provided the link to the google drive from where you can find the sql queries to create these tables and insert the data to those tables. Ideally the data into tblSwapDatabases_New can be inserted by joining the De-normalized table and other 3 normalized tables together. I should have explained that as well during the video. Anyway below is the query to insert the data insert into tblSwapDatabases_New select b.ServerId as BackupServer, c.ServerId as RestoreServer, a.IndexRebuild, a.databasebackup , a.databaserestore, a.databaserename, d.DatabaseId, a.Active from tblSwapDatabases a left join tblServer b on a.databasebackupserver = b.ServerName left join tblServer c on a.databaseRestoreServer = c.ServerName left join tblDatabase d on a.databasename = d.databasename

[@PALLABIDEYDAS]

@@learnssis Thank you so very much Sir! 🙏🙏

[@Yajyaya1616]

Hi Aqil, thanks for the video. In your example, how would you handle updating all the tables once new data comes in? Would you build an SSIS package?

[@learnssis]

First the data will be inserted\updated to all master tables and then to their child tables.

[@Yajyaya1616]

​@@learnssisthanks for the fast response. I am thinking about how to do this properly in SSIS for a dataset being appended daily. My thoughts were: 1. Use a SQL stored proc and a IF EXISTS statement to check if the IDs in the parent tables exist for the corresponding values in the incoming data set - if they dont exist then add them to the parent table(s) 2. For the incoming dataset, change the data so it instead uses the IDs from the parent tables 3. Append the incoming dataset to the existing child tables with the correct IDs Would this be the best way? Thanks again Aqil

[@learnssis]

@@Yajyaya1616You can do the incremental load using lookup transformation kzbin.info/www/bejne/bpW1ep2MnbCigdU

[@learner_SSIS]

Hi aqil sir 😀

[@learnssis]

Hello Naveen Sir