120 How do you implement SCD Type 2 in SSIS Using Lookup

For records that exists in Source and not in destination (new records) from lookup, shouldn't you be using "Lookup No match output" ? How will the new records from lookup pass through Lookup Match Output to Conditional split ?

Hi Aqil, Thanks for your videos on SSIS. I am learning from them very fast. but I have one question I am using SQL Server 2022 and visual studio 2022 version and my processor is i7 still it takes too much time to run SSIS package, can you please suggest what the reason behind it so that I can do more practice on it.
Thanks in Advance🙏

What does buissness key refer to in scd type does it mean foreign key?

Hi aqil, if we want to do scd 2 type using merge function and stored procedure can you please explain how we could do it.

It may not have ideal outcome if a source record has update in some SCD1 attributes and SCD2 attributes at the same time. Good approach and presentation, but might need tweaks for actual implementation.

Please provide document that has solution of steps to implement SCD type2 with out using scd transformation and schedule
the pakage to execute through sqlserver job
suppliersourcetable
Supplier_Key Supplier_Code Supplier_Name Supplier_State
123 ABC Acme Supply Co CA


SCD type2 tracks historical data by creating multiple records for a given natural key in the dimensional tables with CURRENTINDICATOR COLUMN VALUES AS 0 OR 1. Unlimited history is preserved for each insert.

For example, if the supplier relocates to Illinois CURRENTINDICATOR WILL BE 1 FOR THAT NEW LOCATION
OLD LOCATION ROW CURRENT INDICATOR WILL BE 0

At any point of time latest location currentindicator will be 1 all others will be 0

supplierdimension table e with below data after package is run
Supplier_Key Supplier_Code Supplier_Name Supplier_State CURRENT INDICATOR
123 ABC Acme Supply Co CA 0
124 ABC Acme Supply Co IL 1

Just one doubt why we are including columns from reference table in our output in lookup

Good explanation. Very helpful.
But how to create FameSell & FameSellDW databases ?
(SQL queries to create the tables in FameSell & FameSellDW databases is not provided).
Please help.

We need a video on bk and sk

Amazing

I love u sir.
Should I drop the staging tables when finishing the process? what is better for the performance

Hi, why are you pulling through the active row on the Type2 dimension please? Should you not be constraining on the transaction date to choose the correct surrogate key historically? Thanks

Thank you so much for making this beautiful video, I will keep you in my prayers once again thank you much <3

Really good sir 👍

Hi Aqil. This is a great video as always. Can you please consider making a video to switch a fact table that has been maintained as scd1 till now and now the requirement is to convert it to scd2. What if we also need to set some default values for the previous records. How do we set up the first time historical run and incremental run?

thank you

Interview question: If you have 100 data source files and 100 destinations tables in this scenario how many ETL packages will you create?

Thank you.

Excellent! ❤👍! Thank you, Mr. Aqil

Please, anyone, help me to find the script please guide me I want to practice but in goole drive, there are lots of which one is for this vidio i am confused

Thank you

Great Video.. Can you make SCD TYPE 4

Best SCD video. Thank you.

Good job!
Which other ETL tool are you savvy in?
Do you use informatica or do you have any tutorial video recommendations that's as detailed as yours for refreshing?

This is a brilliant attempt. Thanks for all of your efforts. I I have a question. If a record has changes on both SCD type 1 columns & SCD type 2 columns, will the record will be available in both the outputs. Please explain with an example.

best video ever I have seen on slowly changing dimensions. Straight and simple.! You are really doing great job, helping the Integrations development community.
Can you please also tell the types of Keys that generally used in DW. And also what is the difference between BK or SK?

Thank you. Well done.

Best video on SCD implementation !!

In Interview they asked me question, Can you pls tell me most common errors in SSIS you faced till now and how you resolved it.

Thank you sir

Good