3 most common data modeling interview questions

Рет қаралды 28,736

Күн бұрын

Пікірлер: 35

@Sheikh_Nazimuddin 28 күн бұрын

Datalake can contain unstructured, semistructured, and structured all kinds of data. purpose of datalake is to store raw data for various downstream teams. Whereas Data warehouse is for structured data only. It is a read-heavy system for analytical needs. ETL: is used where source data is not bulky and transformation logic is clear for a specific purpose, Only the transformed data needs to be loaded in the target system, enhanced security etc. ELT: is used where a huge volume of data is being processed, and multiple transformation logics will be applied to the raw data by multiple teams, in case of real-time analytics etc. Many to many relationships can be handled by introducing a bridge table between the tables. The bridge table will have 1:M relationship with the other tables.

@josephcarlodavid4355 5 ай бұрын

Great example and shared insights! Very helpful!

@mounikadontha Ай бұрын

Your explanation was so easy to understand like a friend explaining before exam!!!! Please make more videos.. Thank youuuuuu!!

@andreasahrlund-richter2289 5 ай бұрын

Thank you for the nice short summary and your insights Pritha.

@sohammajumder4379 Жыл бұрын

not completely agree with the first difference you explained for ETL vs ELT, both can be used to load data warehouse or data lake, however, the decision on which one should be used is based upon the infrastructure requirement, in ELT you can leverage the power of your target data base for load as well as transformation but in case of ETL you must provision a third server/ compute machine only for the transformation purpose. Happy to read if you have any other view on it..!!

@sandyjust 6 ай бұрын

I agree with you.

@Sheikh_Nazimuddin 28 күн бұрын

correct

@HarshKumar-pw6kg 4 ай бұрын

Please put more videos like this, it is very helpful for student like us. Thanks :)

@AnuragSingh-uq1br 9 ай бұрын

I love your gestures

@user-ep3qz2jx5h 10 ай бұрын

very good explanation

@subhadeepbanerjee3723 Жыл бұрын

Really helpful!

@roymou5856 3 ай бұрын

very helpful, thanks a lot

@rupaghosh6251 Ай бұрын

Nice explanation

@A4Abhinav 2 ай бұрын

Good one ❤

@saikumargudelli 4 ай бұрын

You are a good tutor and a request, why don't you post some tutorials on data modelling that would be helpful. Thank you for this video it is very helpful.

@chpavankumar8040 4 ай бұрын

bane extralu ,,,,,,,

@user-gf1wz4ty1t 4 ай бұрын

very nice

@shrikantjoshi3174 4 ай бұрын

Nicely explained. Thank you. Please keep it up!

@musadiqhussain7840 6 ай бұрын

Can you please tell about the reverse engineering for XML or Oracle DB?

@theWebNet 5 ай бұрын

Can you please post more videos on data modeling. Thanks

@chetankakkireni8870 9 ай бұрын

I can see explanations of 2 questions( i.e., Data Warehouse vs Data Lake and ELT VS ETL) , what is the 3rd data modeling question ?

@ankitsrivastava6756 20 күн бұрын

Nivea body lotion 🧴

@user-dx2dg4bd7q Жыл бұрын

Could you please explain the differences between different data models(Inmon,Kimball,3NF,Dimension Modelling,Data Vault).

@prithachakraborty6023 3 ай бұрын

Sure. In my next tutorial.

@chetanakarte6449 9 ай бұрын

Could you please explain in detail, how to resolve many to many relationships? (I didn't get in this vodeo)

@Ram_jagat 4 ай бұрын

We solve many to many relationships by creating a bridge/ linked table which act as intermediate table between other tables.

@prithachakraborty6023 3 ай бұрын

Sure. Will explain in my next tutorial.

@surajagasti2309 3 ай бұрын

Haeyy

@murchhanabanerjee862 4 ай бұрын

Awesome video পৃথা দি, প্লীজ ডেটা মডেল এর আরো use case video বানান

@A4Abhinav 2 ай бұрын

How to connect with you?

@prithachakraborty6023 2 ай бұрын

Mail me at tina.pritha@gmail.com. I will share my number over mail.

@petebell271 2 ай бұрын

"basically" became Data Redundant .... try to use less.....

@SujeethMaroli--BOSCH 3 ай бұрын

no clear explanation. She might be fresher.

@prithachakraborty6023 3 ай бұрын

Well a Googler and professional data modelling trainer at Please check my linked page for my experiences. It will be really good if you post your questions and ask what exactly you are looking for.

@arpitkapoor2271 Ай бұрын

I don’t feel that explanation was not clear TBH. But ma’am don’t you think that these questions are very simple? Is this truly the level of interviews?