Wow, thank you man! This is a great educative content! There are very few materials on data engineering on youtube. Thank you for filling up this hole!
@surajpatil35792 жыл бұрын
Thanks for covering in such detailed manner 👍 if possible share or make video on common testcase template for etl testing 🙋 keep making content like this @techcoach 👏👏
@TechCoach2 жыл бұрын
Sure Suraj, I will work on them
@nanajama45372 жыл бұрын
Great video! One of the best I’ve come across
@TechCoach2 жыл бұрын
Thanks a lot buddy :)
@ashwinisuryawanshi59472 жыл бұрын
Thanks a lot, this video helped me very much
@TechCoach2 жыл бұрын
I am glad Ashwini, I could help :)
@omkarbelpatre52 жыл бұрын
Thank you so much
@TechCoach2 жыл бұрын
Thanks Omkar :)
@sachingond32292 жыл бұрын
Thanks a lot Bhai!!!
@TechCoach2 жыл бұрын
I am glad I could help :)
@aniketkadam41672 жыл бұрын
How to write test cases.plz share video.
@shivussshetagar28162 жыл бұрын
Rapid changing dimensions are not included in target and it's not the part for reporting .. Please correct me if I'm wrong
@TechCoach2 жыл бұрын
Rapid changing dimensions are normalized in order to reduce the data size , you can use the normalized tables for your reporting without any issues. Infact you find the table with static records used for your reports often.
@KiranTrends Жыл бұрын
Bhai sql queries dedo...scd2 ke all
@prasadkokane75612 жыл бұрын
Hi Sir, my source don’t have unique key it contains duplicates, I just have new business_date every day how I can implement scd type 2?
@TechCoach2 жыл бұрын
Can you please paste the table structure prasad?
@prasadkokane75612 жыл бұрын
@@TechCoach I found solution. I am creating temp table with max business_date and from that temp table, loading into DIM table using Merge statement.
@sachingond32292 жыл бұрын
Can we merge target_backup with new data in source and then minus it from original target to check scd1 i.e. upsert logic testing??
@TechCoach2 жыл бұрын
I am not sure If I understand your questions correctly Sachin