DWH Interview Question :Number of fact and Dimension table in project|TechCoach

[@TechCoach]

Guys please support me in building my new youtube channel "An Indian Abroad " by watching subscribing and sharing with your friends kzbin.info

[@sakshinaik05]

thank you for this video looking forward more proj related and scenario based interview questions

[@TechCoach]

I am glad I could help :)

[@KalyanS]

Great effort thanks for sharing the videos like this

[@TechCoach]

Thanks Kalyan S for the kind words , your support means a lot

[@brothermalcolm]

Great interview breakdown - subscribed!

[@TechCoach]

Thanks a lot Malcolm for the kind words.

[@TOP5-w4n5h]

Nice

[@pritammishra9850]

You made my life simple .

[@TechCoach]

Thanks a lot pritam Mishra for the kind words, I am glad I could help.

[@sai3321]

Somewhere I have seen that star,snowflake can have multi fact tables If star has multi fact tables then what's the difference between galaxy and star schemas

[@dhaswaktheterrificboy1057]

Hi i subscribed . Will you please explain any recent project , in real-time who will create database connection, is etl developer create db connection, in real time how we receive the source bd that help to who is trying for job with 3 to 4 exp

[@avmanu3970]

you have to show some pictorial representation of the facts and dimensions for easy understanding.

[@rocku20081]

@Tech Coach: Hi! After seeing this video, is the pk for the fact table the grain for the fact table as you have mentioned that for the order fact table, the grain is order id. Could you please make me clear on this matter?

[@shanu2576]

Here grain of a fact table mean using what main dimensions tables it is created.

[@azeezahmed7070]

Well Explained. Can you make a video on how to work with Late Arriving Dimensions with an example.

[@TechCoach]

Thanks Azeez for the kind words late dimensions is an interesting concept I will make a video on it soon,Meanwhile I have a small request I am working on this new youtube channel, I Would love it if you watch and subscribe to it as well. kzbin.info/www/bejne/fZ-5n2ajhaeFsJY

[@debashiskumar8775]

Can you please upload a video related to flat file validation and Minus Query with real time scenarios.

[@TechCoach]

Sure, I will try to explain it with an example.

[@chokka1603]

Thank you,can you explain a real time architecture of a healthcare domain

[@TechCoach]

Sure deepika I will try to work on it. Meanwhile I have a small request, I am working on this new youtube channel and will really appreciate if you watch and subscribe to it. kzbin.info/www/bejne/Z2KnfGClrrekopI

[@gyanendrapandey1057]

Hi Vivek Gyanendra is here please send to me how we validate if source is in flat file and target in Data base

[@vishalkumar-le7mu]

hello vivek, the real time scenario is very informative for the beginners as well as experienced can u explain any real time scenarios on health care and banking domains...

[@TechCoach]

Sure Vishal I will work on it, I have a small request I am working on this new youtube channel and would really appreciate if you watch and subscribe to it. kzbin.info/www/bejne/Z2KnfGClrrekopI

[@maqsoodalam4869]

For order-detail will order table become a dimension? If can make dimension model such that order and its detail can be linked then dont need separate separete fact table for order and detail. please clarify

[@infomonk3768]

nice

[@TechCoach]

Thanks a lot Info Monk for the kind words ;)

[@MrMLBson09]

It's redundant to have both Orders and Order Items fact tables. Same business process, with one grain higher than the other. Should just have the lowest level granular table and roll up in your query to a higher grain if needed.

[@TechCoach]

Well It may help speed up things for organizations that tracks millions or orders on a daily basis. In general I agree order items would serve the purpose

[@pujadeokate3044]

hi i am watching your grain video but i can't understand plz explain in breif in another video

[@TechCoach]

Grain is nothing but the lowest level of detail you can fetch from a row in a table. I will try to make the video again. Meanwhile I have a small request, I am working on this new channel and would really appreciate if you watch and subscribe to it. kzbin.info/www/bejne/f4GVh6Fsn7Brfsk

[@venkijaladi823]

Brifely with example sir

[@gyanendrapandey1057]

Hey vivek Gyanendra is Here .please help me for insurance domain validation. and please share video to me with insurance domain for source in flat file and target in database.

[@TechCoach]

Hi Gyanendra, Please refer to this video it may help you. kzbin.info/www/bejne/l4fTYq2vlsSrh9U

[@TechCoach]

I have a small request I am working on this new youtube channel "An Indian Abroad" ,it will really help me if you watch and subscribe to it. kzbin.info/www/bejne/fnO0eZihgpaIaMU

[@aneksingh4496]

I know you have very good content to explain ... but in this video ,you have explained as if you are telling some boring stories ... please explain slowly and if possible bit more interesting

[@TechCoach]

Sure buddy , thanks for the feedback

[@ranjeetreddy8474]

ⁿ0ⁿ