Datawarehousing Concepts Basics (Fact and Dimension Table)

[@venuchode2202]

I have seen many people explaining different concepts, but your explanation is very precise to the point and very understandable and easy to learn. Thank you man!!!

[@surajpatil3579]

Superbly explained within couple of minutes

[@arunabhrana6087]

Please make a video on explaining these questions in the last as there is no next session video is available

[@TechCoach]

Hi Arubabh , I have actually created video on most of the topics. This may help kzbin.info/www/bejne/a5_JeaCebbOmftk

[@TechCoach]

@ Arunabh, please consider subscribing to my new channel it will really help me kzbin.info/www/bejne/bHiUqXqfYqlopdk

[@prakashgadupoodi7549]

Excellent Vivek. Thanks for the nice video. Keep up the great work. Appreciated!!

[@rashmi933]

Thanksyou so much Vivek , very clear concept you have given in this video !

[@polupanda]

Very well explained Vivek. So simple and clear picture on datawarehouse, dimension and fact tables.Thank you

[@skshahbazali6238]

Good Precised video.

[@TechCoach]

Thanks Buddy :)

[@durgaprasadsriramoji5111]

Excellent bro ! Simply superb explanation.

[@TechCoach]

Thanks a lot for the kind words buddy

[@danielkakianurag]

you made it very clear Vivek. Thank you

[@frenchworld8528]

awesome one,getting the courage to know more about fact and dimension table..........

[@govindkota1026]

can you please put your website.

[@TechCoach]

Thanks Guys for the wonderful comments.

[@Argalmani]

nice explanation with very good examples

[@TechCoach]

Thanks for the kind words Rakesh.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/h6PTgZZjjLOdpbc

[@pritomdasradheshyam2154]

thanks for the real time examples, very helpful

[@PAWANYADAV-dq4zg]

Clearly explained

[@TechCoach]

Thanks a lot Pawan :)

[@KalyanS]

nice work. great effort

[@TechCoach]

Thanks buddy for the kind words

[@sam1911ful]

Hi Vivek, Thanks for the informative video series. Could you please post a video explaining how the data at an enterprise level is taken from the source systems and used in ETL for a consumer goods industry. As is where does the data come from for such an enterprise and how is it collected in later used by the ETL team.

[@TechCoach]

Sure Sam, I would try to explain it in one of the videos. I am working on a new video series "An Indian Abroad". I would really appreciate if you watch the video and subscribe to my channel. kzbin.info/www/bejne/fnO0eZihgpaIaMU

[@purinagesh8036]

Too great vedios

[@bhavanisinghsikarwar688]

You nicely explain things but please work on audio and video quality. As I can hear a lot of noise and can't see the picture\tables clearly.

[@TechCoach]

Sure Bhavani, this was my first video, i have tried to improve since

[@mandarTube]

Thanks Vivek. Where is the next consecutive video for datawarehousing concept.? Please share the link.

[@TechCoach]

+Mandar parab I have uploaded another video explaining star and snowflake schema. I will upload more such videos soon

[@urvashiprasad9047]

Thanks for such simple explanation. Really helped!

[@TechCoach]

+Urvashi Prasad Your welcome Urvashi :)

[@softextechnologies9824]

the way you teach is awesome but there is a problem you didn't align your playlist means don't know the sequence of videos. I think you should have to make your tutorials align with numbering

[@vinodgchapre5610]

Very well explanied, thank you

[@MrPinkponk]

Well done.

[@pramodpandey1772]

Thanks a lot. Good explanation!!

[@TechCoach]

Thanks buddy for the kind words. Please consider subscribing to my other channel as well. It will really help me. kzbin.info/www/bejne/bHiUqXqfYqlopdk

[@Santoshkumar-sz3we]

thanks for your values in information. dear plz conformed me DWH is OLTP or OLAP...

[@TechCoach]

Thanks for the kind words Santosh DWH is OLAP system. 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

[@naidugedala2777]

OLAP

[@TechCoach]

I have a small request I am working on this new channel "An Indian abroad" and will really appreciate if you watch and subscribe to it. kzbin.info/www/bejne/Z2KnfGClrrekopI

[@hemantsinghbisht3277]

DWH is basically OLAP and DB is OLTP. As dwh works on historical data

[@techslife-on]

Hi Vivek Nice Effort on this. let me know in which table we can pass the query Dimension or Fact Table or Both hope vl get ans soon...

[@RahulChauhan-hy8ok]

good explaination..liked the eg

[@TechCoach]

Thanks for the kind words Rahul.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/h6PTgZZjjLOdpbc

[@roverteam4914]

I have a few questions in regards to creating dimension and fact tables based on the scenario... Like for Order process, Shipping the order process,calculating the remaining quantity of each product in the warehouse and in some cases the customer returns goods...So in total there are 4 processes, therefore, I need to have 4 fact tables..Am i right?

[@TechCoach]

Hi Rover Team, This video may clarify couple of points , I would be more than willing to answer any doubts you may have after watching this video kzbin.info/www/bejne/pnXPiJtraKx-mNE

[@roverteam4914]

​@@TechCoach I did watch and it helps greatly...I did a task whereby I designed a few dimension and fact tables and would like to clarify if the tables are meaningful....

[@pasarlabhagyaraju9414]

good explanation vivek,but how can i watch your remaining videos

[@Xxx-te6ed]

Pasarla Bhagyaraju 0

[@TechCoach]

+Pasarla Bhagyaraju I have uploaded another video explaining star and snowflake schema. I will upload more such videos soon

[@orrymr]

Good video.

[@shivashankar4202]

Hi vivek!!What are the tables of USER Schema.How should we find out them.TQ

[@TechCoach]

+shiva shankar Can you elaborate your question a little further?

[@shivashankar4202]

Hi vivek..yours videos r useful to DWH testers and developer.Tq for reply.I attend one ETL interview.They asked me "What are the tables which are staring with "STG" key word in USER schema?.that's it

[@thevijay3827]

Hi vivek, good explanation thanks...!!!

[@KalyanS]

Thanks Nice video

[@TechCoach]

Thanks kalyan for the kind words . 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

[@kamleshnakade2277]

Nice Explanation :)

[@kalicharankhetwal]

very nice explanation... Thanks Vivek

[@Xxx-te6ed]

Kalicharan Kc 9878 8999حططططه800 990000088 7

[@rajsahoo1378]

one of the best.. can u please share me the link of your next video on this.. i checked your channel but couldn't found.

[@TechCoach]

+Raj Sahoo I have uploaded another video explaining star and snowflake schema. I will upload more such videos soon

[@kamleshnakade2277]

Where can we find more videos from you?

[@TechCoach]

+Kamlesh Nakade Thanks Kamlesh, Please visit my channel we have few videos on Informatica Scenarios .. More shall follow soon

[@rinijac4439]

where is the next session of DWH ?

[@TechCoach]

These are some of the videos that may interest you. kzbin.info/www/bejne/h6KXqpuedtBsnMU kzbin.info/www/bejne/jqLHi3lmea-ji9U

[@kashishjain8940]

It was good... really helped. :)

[@TechCoach]

Thanks a lot :)

[@KalyanS]

good video

[@TechCoach]

Thanks Kalyan for the kind words,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/door/oLdaMxhfDgdgIAcRGlUvkg

[@malvivente1986]

Good one, thank you!

[@55555siva]

The Best.

[@TechCoach]

Thanks Siva for the kind words :)

[@ashutoshsharma5427]

It helped. Thanks Sir.

[@TechCoach]

+ashutosh sharma Thanks Ashutosh your appreciation encourages me to share my knowledge.

[@aryama28]

Nice expalanation Vivek!

[@TechCoach]

Thanks for the kind words Aryama. 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

[@malakwaseem1166]

When you are manager of data warehouse , how you keep the data validate in term of secure data of validation ? Ans....

[@TechCoach]

I am sorry Malak, Can you elaborate a little more pleasee

[@malakwaseem1166]

Gave me ans of this question

[@maheshbabu-ms6di]

We are expecting more videos

[@TechCoach]

Will be uploaded soon mahesh, Meanwhile I have a small request , I am working on this new channel please do watch share and subscribe to it. Your support is my motivation. kzbin.info/www/bejne/hauXhZWHrNelhbs

[@rakshith3547]

amazing

[@TechCoach]

Thanks for the kind words Rakshit.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/h6PTgZZjjLOdpbc

[@mqtt07]

Bad audio, but excellent content!

[@TechCoach]

I am sorry about the audio, I have some other videos on data warehousing which may interest you with clean audio :)

[@yugioh8810]

It's OLAP not OLTP

[@VijayNaramalli]

Simplified

[@TechCoach]

Thanks a lot Vijay for the kind words :)

[@adibakhann_]

The content is good but the voice is so annoying to listen to. May be you can make it a bit clear and smooth, it sounds like a broken mic has been used. No offense but its difficult to keep listening to. I need to see more but I cant see yours because of poor voice quality, switching to somebody else just for that. Hope you will fix that. Thanks though

[@TechCoach]

Thanks for the advice adiba, I have fixed the voice issues in the recent videos. This may interest you. kzbin.info/www/bejne/a5_JeaCebbOmftk Try watching at 1.5x speed.Happy Learning.

[@pritomdasradheshyam2154]

thanks for the real time examples, very helpful

[@TechCoach]

Thanks Pritom Das for the kind words :)