SCD: slowly changing dimension | slowly changing dimension type 2 | scd type 2 implementation
This video contains detailed explanation with real time example for
SCD : slowly changing dimension | slowly changing dimension type 2 | slowly changing problems
SCD Type 1 - Overwriting
SCD Type 2 - Full history preservation
SCD Type 3 - Partial/Limited history preservation
and scenarios when these types are implemented in data warehousing.
#etlqalabs #slowlychangingdimension #SCD2#etlqalabs
Dear Viewer, if you’re enjoying this video and you’d like to support this channel, please consider subscribing! It might seem small, but hitting that subscribe button helps alot and means more videos in the future!😊
Пікірлер: 10
Really helpful videos
HI SIR..YOU MAY NOT GET TOO MUCH VIEWER SHIP now BUT YOUR VIDEOS HELPING ALOT LIKE ME WHO HAS INTERESTED IN LEARNING(etl),... keep on doing more conceptual videos like where,order,group by,having ..make videos on each topic and give 2 to 3 examples(easy,medium,complex)..have a nice day sir...@@
Really best and helpful explanation.
u r the best sir
your channel will grow soon sir...
Interviewer asked me how did you handle SCD type 2 ? I need answer for this ..... Plz make a video on this
CAN WE VALIDATE SCD WITHOUT CONSIDERING TYPE OF FACT TABLE?
Sir,, in type 2 scd. When the new record is added to the table then the new record should get its own primary key right..?
@divyagarg9836
Жыл бұрын
Yes, right
Your voice is to low