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

  Рет қаралды 15,162

Tech Coach

Tech Coach

Күн бұрын

Пікірлер: 16
@uperwala
@uperwala 4 жыл бұрын
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)
@NaturalPro100
@NaturalPro100 Жыл бұрын
Very well explained in simple words.
@techslife-on
@techslife-on 2 жыл бұрын
Thanks for your effort
@TechCoach
@TechCoach 2 жыл бұрын
I am glad I could help :)
@fahrezaekapurwandani5444
@fahrezaekapurwandani5444 2 жыл бұрын
Thankyou
@shreelekhamandhare7750
@shreelekhamandhare7750 5 жыл бұрын
Hi Vivek, Could you please make videos on performance improvement on SQL queries with different real time scenarios? It would be very helpful.
@TechCoach
@TechCoach 5 жыл бұрын
Sure Shriya, I am working on new videos. I will upload them soon. Meanwhile 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
@dn9416
@dn9416 5 жыл бұрын
Thank you Vivek
@TechCoach
@TechCoach 5 жыл бұрын
Thanks D N 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
@dn9416
@dn9416 5 жыл бұрын
@@TechCoach sure
@ankushgondane8642
@ankushgondane8642 5 жыл бұрын
Hi Vivek, Do you have any idea on implementing CICD pipeline on informatca developer?
@TechCoach
@TechCoach 4 жыл бұрын
I will have to check it Ankush , I haven't worked on it :(
@PuneetSGoyal
@PuneetSGoyal 5 жыл бұрын
Please create a video on Oracle architecture PGA SGA
@TechCoach
@TechCoach 5 жыл бұрын
Hi puneet, I have noted it down and I will work on it. Meanwhile this video may interest you as well. kzbin.info/www/bejne/eoO9dJulgbWGg5o
Rapidly Changing Dimensions | Fast Changing Dimensions
5:08
Tech Coach
Рет қаралды 5 М.
What is ETL | What is Data Warehouse | OLTP vs OLAP
8:07
codebasics
Рет қаралды 434 М.
So Cute 🥰 who is better?
00:15
dednahype
Рет қаралды 19 МЛН
小丑女COCO的审判。#天使 #小丑 #超人不会飞
00:53
超人不会飞
Рет қаралды 16 МЛН
“Don’t stop the chances.”
00:44
ISSEI / いっせい
Рет қаралды 62 МЛН
Let's Compare the Kimball and Inmon Data Warehouse Architectures
5:16
Database Sharding and Partitioning
23:53
Arpit Bhayani
Рет қаралды 106 М.
SCD: Slowly changing dimensions explained with real examples
25:43
DWH Interview Question : Granularity in Datawarehousing
18:36
Tech Coach
Рет қаралды 16 М.
Solving one of PostgreSQL's biggest weaknesses.
17:12
Dreams of Code
Рет қаралды 222 М.
Data Mart Design - Populate Dimensions and Fact Tables
29:30
Clinton Daniel
Рет қаралды 71 М.
Data Mart vs Database vs Data Warehouse vs Data Lake Explained
8:54
Learn with Whiteboard
Рет қаралды 40 М.
So Cute 🥰 who is better?
00:15
dednahype
Рет қаралды 19 МЛН