Hey James, I've taken your Microstrategy Architecht course at uDemy and it was amazing. I wonder if you can make some video showing how to populate a scd type 2 just having only the effective date in your source data. Can I accomplish that with a full outer join? Thanks in advance.
Thank you so much for the kind words, I love reading comments like this. I agree with you, I should make a video covering slow changing dimensions. They are a tricky subject!
Realized I didn't answer your other question, if you only have an effective date and cannot change the underlying tables, I would probably create a logical table to add the end date. Using SQL you can figure out the current record and calculate the end date.
Hi james..how we have to do data validation in microstrategy? If we copy and run the same microstrategy generated sql in DB.. it gives the same result. So it doesn't have meaning. How to do validation. Please make a video in it.
@@JamesOliver hi James, love your videos but if full outer joins are slower than say the Union all, then why should we show them more love and why should we use them?
Lyndon Gray I just meant slower when compared to inner join for example not necessarily unions so you wouldn’t want to use them in place of other join conditions. Joining is usually always the best approach and best used to avoid doing something with multiple steps and long queries. This join should be a part of any sql developers toolbox. And thanks for watching! :)
Beautiful !! I was always wondering the purpose of full outer join
Perfect!! I have suscribed your channel. Thanks for these great tutorial.
I am there to like good content videos.. till now not disappointed with any video.. 😊
Thanks so much. Comments like this keep me going. :)
nice tutor
Learned something new: COALESCE. In the past I would use "If A.ExportDate is not null then A.exportdate else b.importdate"
Hello James.. could you please make a video on document properties like font, border, grid overflow properties. Kindly make a video.
Thanks
have a sample program
Hey James, I've taken your Microstrategy Architecht course at uDemy and it was amazing.
I wonder if you can make some video showing how to populate a scd type 2 just having only the effective date in your source data. Can I accomplish that with a full outer join?
Thanks in advance.
Thank you so much for the kind words, I love reading comments like this. I agree with you, I should make a video covering slow changing dimensions. They are a tricky subject!
Realized I didn't answer your other question, if you only have an effective date and cannot change the underlying tables, I would probably create a logical table to add the end date. Using SQL you can figure out the current record and calculate the end date.
Hi james..how we have to do data validation in microstrategy? If we copy and run the same microstrategy generated sql in DB.. it gives the same result. So it doesn't have meaning. How to do validation. Please make a video in it.
I really like this idea. Thank you for suggesting. Walking through data validation / troubleshooting is an excellent idea I did not think of before.
@@JamesOliver.. thanks a ton James.. 🙏
James, can we extend the love of full outer joins by always using a full outer join and then filtering out the fields or records we don't desire?
Haha I guess in theory you could but full outer joins are slow in performance compared to the other joins. But I love this comment! :)
@@JamesOliver I didn't realize that there might be a performance issue, but your answer helps to clarify my understanding of joins.
@@JamesOliver hi James, love your videos but if full outer joins are slower than say the Union all, then why should we show them more love and why should we use them?
Lyndon Gray I just meant slower when compared to inner join for example not necessarily unions so you wouldn’t want to use them in place of other join conditions. Joining is usually always the best approach and best used to avoid doing something with multiple steps and long queries. This join should be a part of any sql developers toolbox. And thanks for watching! :)
Hi James, can you please do a video on Memory COntract Manager
Interesting idea. I must admit I don't know much about it.
Love ur content
Really appreciate it! :)
Leans too much on coalesce. Close...