Checkout the Big Data course details here: trendytech.in/?referrer=youtube_bd12
@abhijeetghosh80732 жыл бұрын
Tried looking for defination in many videos but the way you explained really made it easy to understand. Thanks for sharing knowledge 🙏
@rishabh314152 жыл бұрын
Got this question in Amazon DE interview round 1
@Youtuz1242 ай бұрын
Very well explained, especially the ETL Vs ELT, Thank you Sumit!
@funtime123452 жыл бұрын
What an amazing explanation sir!!! Superb!! Love it!!! You are great sir!!!
@sumitmittal072 жыл бұрын
Thanks a ton. Keep watching
@ashutoshsharma33962 жыл бұрын
Thanks for this video! In our project we were loading data from oracle db to Teradata stg tables using informatica one to one mapping and after loading to stg tables were doing transformations and loading dimension and fact tables so it was ELT process.
@nklee1980 Жыл бұрын
Your explanation 100% very clear and understanding.....
@devasaniganesh81962 жыл бұрын
You made this easy to understand, Thank you sir.
@sumitmittal072 жыл бұрын
Happy to hear that!
@JuniorMarci27 Жыл бұрын
Perfect explication! Thanks!!! You changed my mind about this subject.
@ushavr Жыл бұрын
Very thorough and helpful! Easy to understand. Thanks
@ishaqkhan86535 ай бұрын
Thank you for the wonderful explanation. It was simple and crisp
@arpangupta21622 жыл бұрын
it was a much needed session
@sumitmittal072 жыл бұрын
Happy that you found the session useful!
@rakish81 Жыл бұрын
Superb & Informative! nicely articulated.
@abhijeetpatil89582 жыл бұрын
Now I understand better
@shreyashwaghmare9136 Жыл бұрын
Bro your video helped me a lot. Thanks man
@udaypatilSiR Жыл бұрын
Sumit sir really hats off to you.
@MSG_22 Жыл бұрын
It was simple and clear, thank you
@andreanlobo73732 жыл бұрын
Extremely useful. Thanks for this video and all the valuable information
@nandansingh14822 жыл бұрын
Very well explained thanks a lot
@VikashSoni-o3z Жыл бұрын
Nice explanation
@gerardt.51722 жыл бұрын
Great explanation and very esay to follow!👍 Thanks!
@avinashshinde2659 Жыл бұрын
excellent,got Deep knowledge!
@ganish54312 жыл бұрын
Good explanation..!
@ravirajchenna6122 жыл бұрын
Loved the explanation
@madhavareddy3488 Жыл бұрын
Nice one!! Thanks!
@ameerullah22608 ай бұрын
Super awesome
@MJoe-fb9ps Жыл бұрын
Awesome
@omkarm78652 жыл бұрын
can we use Oracle also as data warehouse because as far I know Teradata is also database only. so any database available in market, we can use that as data warehouse. Am I correct?
@sonu-if4ym2 жыл бұрын
Yup.. We have used oracle as dwh
@nvasudeva Жыл бұрын
While technically u could use but this would be at the cost of performance. Please note that traditional databases works on rows where as typical DWH database is configured to operate in columnar fashion.
@dishashetty866 Жыл бұрын
Is Google Cloud Storage a database or a data lake?
@alessandroceccarelli6889 Жыл бұрын
Can MongoDB, with its analytical engine and Time Series collections, be considered a hybrid DB/Warehouse? Would it be inherently wrong to store e.g. historical sales transactions of a shop and current transactions within a Time Series Collections on Mongo? If not, which alternative would you consider for it? Thank you so much for your video 👏🏻👏🏻
@dhruvpandey11892 жыл бұрын
Are datawarehouse and data lake different sections of the same set up? For example if we have a snowflake DW, can the data lake be also within the same snowflake set up but an isolated environment?
@vandanasharma4738 Жыл бұрын
Snowflake is created/hosted on any of the three clouds we have. So as per my understanding, snowflake is data warehouse but it can be used as a datalake as well. When used as a datawhere house it stores the data in snowflake itself but when you use it as a data Lake, it keeps or make use of Amazon S3 for example bucket for storage
@vandanasharma4738 Жыл бұрын
Please correct for better understanding
@prajitkarande52142 жыл бұрын
Can we use ELT for datawarehouse ? Ca we store log file as it in datawarehouse if yes then what's exactly different between data warehouse and data lake?
@ANKITKUMAR-nv8ur2 жыл бұрын
No in data warehouse we can not store log file as it is unstructured data. but in data lake we can have unstructured and structure data that's the difference exactly
@gcpchannelforbegineers70802 жыл бұрын
Thanks for the amazing content :)
@AbhishekTiwari-vf9ru2 жыл бұрын
I have a doubt , does datawarehouse supports acid properties? Also is only historical data stored in datawarehouse?
@vandanasharma4738 Жыл бұрын
The idea behind developing data warehouses is to keep historical data you can relate it with a normal datawhere house people are using to store goods so it's a kind of storing huge amount of data
@gopinathg3182 жыл бұрын
If we cannot store historical data in data base then how we will copy those data to a data warehouse to do analysis.
@vandanasharma4738 Жыл бұрын
So what happens is when you have data in a database then on regular intervals we move this data from database to a datawarehouse using an ETL tool. So the data flows from your database -> then ETL tool ~> then a datawarehouse. The frequency at which you move data from a database to a data warehouse is generally suggested by the clients or the business users
@deepanshujain41192 жыл бұрын
Can a database become a datawarehouse and visa versa?
@MaheshTiwari-hq7lr9 ай бұрын
both have certain limitations as discussed in the video.
@ashutoshyadav83482 жыл бұрын
Why cost of storing data in database is high?
@ramm3020 Жыл бұрын
May be onpremises storaege . now due to cloud the storage cost comes down. Pls comment it is correct or not. THanks.