What is a data warehouse?
A data warehouse is a repository that stores all of an organization’s current and historical data from disparate sources - it’s sometimes called a single source of truth. It’s a key component of a data analytics architecture that creates an environment for decision support, analytics, business intelligence (BI), and data mining.
What is a data mart?
A data mart is similar to a data warehouse, but it holds data only for a specific department or line of business, such as sales, finance, or human resources. A data warehouse can feed data to a data mart, or a data mart can feed a data warehouse.
Data warehouses and data marts hold structured data, and they’re associated with traditional schemas, which are the ways in which records are described and organized. Whichever repository they choose, businesses use an ETL tool to extract data from various sources and load it into the destination.--
Ralph Kimball Approach: first data mart then combine way data warehouse.
-----
Bill Inmon Approach: First data warehouse later data mart.
----
If you’ve enjoyed this video. Like and Subscribe to my channel for more similar informatica interview videos and tutorials.
Got any questions about informatica interview? Ask me in the comment section below.
------------------------------
Why should you watch my channel?
Informatica is the market leader in the ETL segment. I am working as senior ETL developer for 10+ years in North Carolina, USA and want to help and share realtime and scenario based tutorial to prepare for interview.
Who should watch this video?
If you are fresher or already working but looking to refresh SQL, Informatica, ETL, Data warehousing concepts for interview.
For more Information:
Please visit my other platforms.
Website: www.informaticainterview.com
LinkedIn: www.linkedin.com/in/informatica-interview-prep
Or contact me by email: informaticainterviewhelp@gmail.com