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 th-cam.com/video/c2lSKLQPb_I/w-d-xo.html How do you load a fact table th-cam.com/video/duaR_PhLdmc/w-d-xo.html
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 th-cam.com/video/7uj463csru0/w-d-xo.html
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
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..
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.
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)
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.
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.
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.
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.
![[ENGSUB] UNPRODUCTIVE DAY ใช้ชีวิต (เปื่อยๆ) ด้วยกัน 1 วัน! | OUROAD CLOSEFRiEND SS2 EP.9](http://i.ytimg.com/vi/pyYKZ3kra9w/mqdefault.jpg)
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.
Thanks for your comment. Means a lot to me.
Your way of teaching with examples explains everything so clearly, just loved it.👏
Thank you Ashab.
Wow! You taught it so well that I understood SCD in less than 13 minutes. Many thanks.
Glad to know that it helped you.
He explained in proper way to get better understanding without having any doubt and it can be easily implement.
Thank you Sanjit.
I 100% agree with all the guys who said this video explain the SCD topic in a simple yet powerful way ! VERY WELL DONE!
Thank you Imran Sir.
You made all concepts clear! Thanks Aqil
Glad to know that it helped you in some way.
Best example I have seen to understand this tool
Thank you for your comment. Good to know that you liked the video.
Great, Explained very clearly without any confusion.
Thanks Phani for your comment. Good to know that you liked this video.
Brother Aqil, your presentation and explanation are excellent! It is really easy to understand. Many thanks.
Thanks Brother for your comment. Good to know that you liked the video.
Really appreciated on detail videos on SSIS.
You are most welcome Sumit.
Great great brother your doing a best job... Scd is clear
Hi aqil ,
Nice video. i saw so many Videos on SCD But yours is clear and easy to understand.Thank you so much
Glad you liked the video.
Thank you for the wonderful videos for us (SSIS Community )
Thank you for your comment.
It's really helpful for me. Thanks a lot
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
th-cam.com/video/c2lSKLQPb_I/w-d-xo.html
How do you load a fact table
th-cam.com/video/duaR_PhLdmc/w-d-xo.html
Very well explained. Thank you very much!
Its good to know that you liked the video Juan Hernandez.
You made all concepts clear!
Glad you liked the video Priyam.
Thanks a lot, it reallyt well explained.
Glad it worked for you.
thank you, brother, as always great stuff.
Good to know that you liked the videos.
Very clear explanation....Thanks
Glad you liked the video.
Very well Explained. thank you Sir!
Thank you Srikanth.
Great sharing, thanks a lot
You are most welcome Reza.
This is a very clear explanation. Thank you.
Nice to hear that you liked it.
clear my all doubt ,Nice Video ahmed..
Thank you Ajeet bhai.
Can you please tell us how you have done the transformation part after slowly change dimension in data flow.
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
th-cam.com/video/7uj463csru0/w-d-xo.html
@@learnssis Ok Sir I got it. Thank you so much.
@@shubhamshukla3913 No problem.
Very nice explanation brother.
Glad you liked the video.
Thank you for the clear explanation Aqil
Thanks for your comment.
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
Sorry at the moment I am of station and won't be able to check this soon.
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..
You got a 5 star for this video from my side.
Thank you Merin for your comment, Glad to hear that you liked it.
Do you have a tutorial on how to load data to Fact Table using this SCD Type 2 with Start Date and End Date?
7:22 sir in case, that StartDate column and EndDate column is appearing as blank. Please give me solution for this.
Your videos are short n sweet...
Thank you Sagarika for your comment.
Thank you so much sir
You are most welcome Skylean.
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.
@venkatsaikumar4746 Hi, you need to maximize the window to see the dropdown option
How do I make startdate the same as hiredate in my type 2 dimension
Excellent . Thank you !
Thank you.
Great video eas to follow and cmprehend
Thanks for your comment.
very clear and perfect ... thanks...
Thank you Virag for you comment. Its nice to hear that you liked it.
thanl you so much 🙏🙏
You are most welcome Sir.
Great! Nicely presented
Thanks for your comment. Good to know that you liked the video.
this was very helpful .. thank u so much ....keep up the good work
Thanks for your comment, good to know that you liked the content.
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)
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.
Thanks!!
You are most welcome Ausubel.
Nice one. Appreciate the efforts. Thanks.
Nice to hear from you. Thanks.
Good Explanation
Thanks Sai for your comment.
Great job.
Good to know that you liked the video.
Thanks you so much ❤️
You are most welcome.
great example
Thanks
Great !!! Congrats and thks .
Good to know that you liked the video. Thanks.
its very clear. Can you also do similar video for fact table
Thanks. Sure I will do this in coming days.
Nice explanation
Tks
Thanks, good to know that you liked the Video.
hi aqil, when i choose destination table in scd transformation i didn't see emp_id column could you please tell me the reason
Please double check the table meta data, it should be there.
8:40 By which query you have copied all records from source to destination?
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.
@@learnssis thank you 🙏 I appreciate your efforts 🙏
nice video and congrats to jyoti singh for marrying bhandari
Ha ha. very funny.
Excellent
Thank you for your comment.
But you are puting the source table and target table in the same BD !
Good on you champ
ha ha, I am a learner too.
The time didnt updated for SCD1 ?
I will check that out but below is the fastest method to run for SCD Type 1, SCD Type 2 and fixed attribute
th-cam.com/video/7uj463csru0/w-d-xo.html
Best
Thank you.
What is use of inferred?
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.
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.
Sure, I will make a video on this.