42 Slowly Changing Dimension in SSIS

Slowly Changing Dimension in SSIS | Using Slowly Changing Dimension in SSIS
Download the file\script used in the Video from below link
drive.google.com/drive/folder...
SSIS Tutorials: • SSIS Tutorials
SSIS real time scenarios examples: • SSIS real time scenari...
SSIS Interview questions and answers: • SSIS Interview questio...
Slowly Changing Dimension in SSIS
What is the use of slowly changing dimension in SSIS?
What are the 4 types of slowly changing dimensions?
Which dimension is slowly changing?
What is slowly changing dimension in SQL Server?
Happy Learning.
If you have any questions or suggestions please comment on the video or write to me at “[e-mail]”

[@reddyabhik]

Well explained on all 3 types of SCD transformation. I really loved the way you simplified in precise way. Now I am very clear on SCD transformation.

[@learnssis]

Thanks for your comment. Means a lot to me.

[@inspired7606]

thank you, brother, as always great stuff.

[@learnssis]

Good to know that you liked the videos.

[@phanichaitanya8829]

Great, Explained very clearly without any confusion.

[@learnssis]

Thanks Phani for your comment. Good to know that you liked this video.

[@shekharmulye1322]

Great great brother your doing a best job... Scd is clear

[@sanjitkumar3110]

He explained in proper way to get better understanding without having any doubt and it can be easily implement.

[@learnssis]

Thank you Sanjit.

[@ashabhumza3394]

Your way of teaching with examples explains everything so clearly, just loved it.👏

[@learnssis]

Thank you Ashab.

[@MOHAMMED-vo4gl]

You made all concepts clear! Thanks Aqil

[@learnssis]

Glad to know that it helped you in some way.

[@mohammadsi678]

Brother Aqil, your presentation and explanation are excellent! It is really easy to understand. Many thanks.

[@learnssis]

Thanks Brother for your comment. Good to know that you liked the video.

[@imranamjad4294]

I 100% agree with all the guys who said this video explain the SCD topic in a simple yet powerful way ! VERY WELL DONE!

[@learnssis]

Thank you Imran Sir.

[@haatpraat2993]

This is a very clear explanation. Thank you.

[@learnssis]

Nice to hear that you liked it.

[@oladman9058]

Wow! You taught it so well that I understood SCD in less than 13 minutes. Many thanks.

[@learnssis]

Glad to know that it helped you.

[@priyam_1007]

You made all concepts clear!

[@learnssis]

Glad you liked the video Priyam.

[@assiassou9621]

this was very helpful .. thank u so much ....keep up the good work

[@learnssis]

Thanks for your comment, good to know that you liked the content.

[@seshubabudabbakuti6301]

Thank you for the wonderful videos for us (SSIS Community )

[@learnssis]

Thank you for your comment.

[@koushalpatel]

Nice one. Appreciate the efforts. Thanks.

[@learnssis]

Nice to hear from you. Thanks.

[@Juan-Hdez]

Very well explained. Thank you very much!

[@learnssis]

Its good to know that you liked the video Juan Hernandez.

[@viragjagtap5807]

very clear and perfect ... thanks...

[@learnssis]

Thank you Virag for you comment. Its nice to hear that you liked it.

[@vin.sri.69]

Very well Explained. thank you Sir!

[@learnssis]

Thank you Srikanth.

[@sumitawate9150]

Really appreciated on detail videos on SSIS.

[@learnssis]

You are most welcome Sumit.

[@ajeetverma1902]

clear my all doubt ,Nice Video ahmed..

[@learnssis]

Thank you Ajeet bhai.

[@zenaronline9064]

Great! Nicely presented

[@learnssis]

Thanks for your comment. Good to know that you liked the video.

[@hazemnz]

Thank you for the clear explanation Aqil

[@learnssis]

Thanks for your comment.

[@vinivsetlur6850]

Excellent . Thank you !

[@learnssis]

Thank you.

[@stealthassulter]

Best example I have seen to understand this tool

[@learnssis]

Thank you for your comment. Good to know that you liked the video.

[@satellitepop]

Great !!! Congrats and thks .

[@learnssis]

Good to know that you liked the video. Thanks.

[@sandeepkoosul3661]

Very clear explanation....Thanks

[@learnssis]

Glad you liked the video.

[@satyavanidaparthi9020]

Hi aqil ,
Nice video. i saw so many Videos on SCD But yours is clear and easy to understand.Thank you so much

[@learnssis]

Glad you liked the video.

[@hemachitikina9466]

It's really helpful for me. Thanks a lot

[@learnssis]

Glad to know Hema, it helped you.
If you want to see how to load Dim and Fact tables then you can watch below videos
How to load dimension table in sql using ssis
ruclips.net/video/c2lSKLQPb_I/видео.html
How do you load a fact table
ruclips.net/video/duaR_PhLdmc/видео.html

[@saadrouane6521]

Great video eas to follow and cmprehend

[@learnssis]

Thanks for your comment.

[@data-dynamo-guy]

Thanks a lot, it reallyt well explained.

[@learnssis]

Glad it worked for you.

[@rezabahadorizadeh]

Great sharing, thanks a lot

[@learnssis]

You are most welcome Reza.

[@mduoonus656]

Nice explanation
Tks

[@learnssis]

Thanks, good to know that you liked the Video.

[@samderrty123]

How do I make startdate the same as hiredate in my type 2 dimension

[@sharadgawade9408]

Very nice explanation brother.

[@learnssis]

Glad you liked the video.

[@khwong98]

Great job.

[@learnssis]

Good to know that you liked the video.

[@venkatsaikumar4746]

Hi Aqil, while checking with SCD I'm unable to select variable(there is no dropdown) for start and end date can you please help me with this (@7:35 in the video)
Thanks in advance.

[@RamRam-ce2yk]

Thanks you so much ❤️

[@learnssis]

You are most welcome.

[@compartiendo_conocimiento]

Thanks!!

[@learnssis]

You are most welcome Ausubel.

[@subhajitdas660]

7:22 sir in case, that StartDate column and EndDate column is appearing as blank. Please give me solution for this.

[@skyleaned]

Thank you so much sir

[@learnssis]

You are most welcome Skylean.

[@MerinNakarmi]

You got a 5 star for this video from my side.

[@learnssis]

Thank you Merin for your comment, Glad to hear that you liked it.

[@MerinNakarmi]

Do you have a tutorial on how to load data to Fact Table using this SCD Type 2 with Start Date and End Date?

[@afonsovaz4186]

thanl you so much 🙏🙏

[@learnssis]

You are most welcome Sir.

[@saikirankyasa1836]

Good Explanation

[@learnssis]

Thanks Sai for your comment.

[@pritambose3439]

Excellent explanation...if i want a scenario where i have start date and update date and i am using scd type 1 where with each update the update date will change then how to do the configuration (I could do a scd type 1 without this transformation and implement the same but this seems easier)

[@learnssis]

Yeah it generates the code automatically for you. If you want to update the value of update date for each update, then you might need to alter the code generated by SCD and put your update query inside OLE DB Command transformation.

[@marudhu1995]

its very clear. Can you also do similar video for fact table

[@learnssis]

Thanks. Sure I will do this in coming days.

[@aamirirfan8768]

Good on you champ

[@learnssis]

ha ha, I am a learner too.

[@user-iu1sv4jr7z]

Excellent

[@learnssis]

Thank you for your comment.

[@viswanathp6305]

hi aqil, when i choose destination table in scd transformation i didn't see emp_id column could you please tell me the reason

[@learnssis]

Please double check the table meta data, it should be there.

[@valijoneshniyazov3859]

great example

[@learnssis]

Thanks

[@sagarikadevi4869]

Your videos are short n sweet...

[@learnssis]

Thank you Sagarika for your comment.

[@shubhamshukla3913]

Can you please tell us how you have done the transformation part after slowly change dimension in data flow.

[@learnssis]

Actually slowly changing dimension itself generate all the code inside the data flow task. I have not added the extra code here, although if you want to make any change to slowly changing dimension then you can do this.
Although a better and faster approach to implement this will be doing this using Lookup transformation, in SCD we use OLE DB Command which is slow, thus we normally implement it using Lookup transformation. You can check it below how to implement this
ruclips.net/video/7uj463csru0/видео.html

[@shubhamshukla3913]

@@learnssis Ok Sir I got it. Thank you so much.

[@learnssis]

@@shubhamshukla3913 No problem.

[@shrinivaskashettiwar3482]

Hi Aqil,
I am not able to see drop down of Variable to set date values, in historical attribute options.
Could you please help with this issue asap.
Thanks

[@learnssis]

Sorry at the moment I am of station and won't be able to check this soon.

[@tejaswinerella5223]

Hi Shrinivas,
I'm also facing the similar issue
I am not able to see a drop-down of Variable to set date values, Fixed Attribute
the option is in the disabled state not able to enable it
if you resolved your issue..?
could you please help me with this..

[@anandmiryala4901]

The time didnt updated for SCD1 ?

[@learnssis]

I will check that out but below is the fastest method to run for SCD Type 1, SCD Type 2 and fixed attribute
ruclips.net/video/7uj463csru0/видео.html

[@umeAsh393]

8:40 By which query you have copied all records from source to destination?

[@learnssis]

If you check the video from 8:10 then there was no data into into DimEmployee, I executed the SSIS package which inserted the data from source to destination table.

[@umeAsh393]

@@learnssis thank you 🙏 I appreciate your efforts 🙏

[@hamzah1738]

But you are puting the source table and target table in the same BD !

[@DoctorDatah]

Best

[@learnssis]

Thank you.

[@armansaleem3781]

nice video and congrats to jyoti singh for marrying bhandari

[@learnssis]

Ha ha. very funny.

[@ankitsaxena6188]

What is use of inferred?

[@learnssis]

Hi Ankit, inferred option is used when a record exists in Fact table, however its corresponding data is not yet present in the Dimension table. So if a record was marked as inferred record then whenever the data will be available in future in the source table, same record will get updated to Dimension table.

[@MerinNakarmi]

1. If a record exists in Fact Table and its corresponding data does not exist in Dimension Table, cube processing fails. How will it work. Will an entry be automatically made on the dimension table? If you can make a video on this one also, that would be great.

[@learnssis]

Sure, I will make a video on this.