Data Mart|Data mart tutorial|Data Mart architecture|Data mart in data warehouse

preview_player
Показать описание
The video answers what why and how of a datamart.
Datamart is focused on a single functional area of the organization.
It can be broadly classified into 3 categories on the basis of sources
Independent datamart
Dependent datamart
Hybrid datamart
Watch the video to learn everything about datamart
#Datamart #datamartarchitecture #techcoach
Рекомендации по теме
Комментарии
Автор

When do I need a warehouse and when do I need a data mart?
1) For a small and medium company I may venture building a warehouse. Depends really on complexity and diversity.
2) For really large companies with diverse information, I would have a strategy for warehouse and start with data marts for specific areas and keep at designing the warehouse to get information pertinent to the management/operations of the entire company as a whole (a special data mart in that sense)

uperwala
Автор

Hi Vivek,
Could you please make videos on performance improvement on SQL queries with different real time scenarios?
It would be very helpful.

shreelekhamandhare
Автор

Hi Vivek, Do you have any idea on implementing CICD pipeline on informatca developer?

ankushgondane
Автор

Please create a video on Oracle architecture PGA SGA

PuneetSGoyal