Datawarehouse Concepts | Types of Dimensions | Dimensional attributes|h2askills|scd

  Рет қаралды 118,096

h2askills appletech

h2askills appletech

Күн бұрын

Пікірлер: 37
@tultul49
@tultul49 9 жыл бұрын
I found the DWH demonstration very informative and vey clear. Thanks very much for sharing.
@samita5373
@samita5373 9 жыл бұрын
Very systematically demonstrated...very clear n simple to understand. Thanks sir.
@koolkam20
@koolkam20 10 жыл бұрын
SIMPLE AND TO THE POINT EXPLANATIONS- EXCELLENT- THANK U SIR.
@gangkiran5653
@gangkiran5653 10 жыл бұрын
Awesome explation....Thanks .....for uploads....... expecting More Videos.....
@deeptiacharya7012
@deeptiacharya7012 6 жыл бұрын
Very informative and concept explained in a very simple way.Thank you very much for sharing .
@KrishnaRaj-ty2sp
@KrishnaRaj-ty2sp 6 жыл бұрын
This video made me to grasp the concepts in more effective way than others. I would recommend this video for those who to start from scrap..
@noeldsouza7909
@noeldsouza7909 9 жыл бұрын
excellent teaching skills!
@yadagirivadla7510
@yadagirivadla7510 9 жыл бұрын
It's so useful and very informative...... Thanks alot...
@sanjayshende5632
@sanjayshende5632 8 жыл бұрын
this is the best video I have watched on this subject till date, hats off sir !
@krishnaprasadchalluru4486
@krishnaprasadchalluru4486 6 жыл бұрын
Concepts explained well.. kudos to the speaker.
@KanagaveluSugumar
@KanagaveluSugumar 9 жыл бұрын
Excellent, very useful. Thank you!
@Tt-ds5cu
@Tt-ds5cu 3 жыл бұрын
Hello, Thank you for sharing information and for the video. I have some questions: 1. Do we generate fact tables based on surrogate key? these keys are artificial generated. If our fact table saves facts for customer related data such as total sales , total profit for customer, so: 2. since fact table is generated with surrorage key of dimension table, we will have more data for the same customer on fact table. what should be the structure of the fact table in this case to find total profit of one specific customer? 3. if somehow our dimension is truncated, deleted, we could generate dimension from source tables but we cannot generate same surrogate key again for the same customer if we use sequence. I mean if we loose relation between surrogate key and customer, our all fact tables will be useless based on customer surrogate key. How can we handle this situation? Should we generate surrogate keys not from sequence but from some algorithm that will include natural key, so we can genearate same key for the same customer again? thank you
@vemparalasuresh
@vemparalasuresh 10 жыл бұрын
Nice explanation , simple language with good example.
@madhavareddy3927
@madhavareddy3927 9 жыл бұрын
Well explained!! ..Looking more similar videos
@vasanthnaidu9689
@vasanthnaidu9689 10 жыл бұрын
Dear SIr, Thanks lots for the excellent explanation and real time scenarios and clarity you provided us in this tutorial.....thanks lots sir
@vijaya1279
@vijaya1279 10 жыл бұрын
More information in less time simple n sweet great.... Regards Vjai
@rajneeshverma1
@rajneeshverma1 9 жыл бұрын
Thanks - Found useful and explanatory!
@ManaMaruti
@ManaMaruti 7 жыл бұрын
Thank you sir !! One of the best videos.
@venkateswararaonani6851
@venkateswararaonani6851 9 жыл бұрын
awesome explanation sir expecting more videos on datawarehouse concepts pls...... than q
@paulocampo7574
@paulocampo7574 10 жыл бұрын
Good Explanation and simple examples, please post some more topics on data warehousing, or show a Case Study
@pavanmadamset
@pavanmadamset 7 жыл бұрын
Thank You Very Much Sir! /\ Your Video Helped me to Enhance my Knowledge About Data Warehouse
@Dhivya88
@Dhivya88 8 жыл бұрын
Excellent video thank u sir :) :)
@Kirankumar-xy9zw
@Kirankumar-xy9zw 8 жыл бұрын
Thanks sir... good Explained
@prabhuv7527
@prabhuv7527 10 жыл бұрын
It was excellent thanks...
@PhaniKatakam
@PhaniKatakam 7 жыл бұрын
Hats off you to sir! for keeping this in public! /\
@nuwansamarasinghe1456
@nuwansamarasinghe1456 9 жыл бұрын
I have counted you spelled 320 OK's in a span of 1hour 9minutes. What speech sir ji. OK OK great.
@PhaniKatakam
@PhaniKatakam 7 жыл бұрын
Nuwan... start focusing on Life and subject in this video... else you would hear only fillers..you are one waste of creator's magic!
@dataarchitect841
@dataarchitect841 7 жыл бұрын
nice course on data modeling: www.udemy.com/datamodeling/?couponCode=PROMO17
@harryk1317
@harryk1317 10 жыл бұрын
good intro Thanks!
@raghavaprasad8706
@raghavaprasad8706 10 жыл бұрын
do you have continution of this video please? .can you please upload or provide us link
@nasimchaklader126
@nasimchaklader126 9 жыл бұрын
Can i get notes of this video?
@m3assetsllc439
@m3assetsllc439 7 жыл бұрын
What did he say?
@ericemericaful
@ericemericaful 8 жыл бұрын
AHK Abdubbaa bindobo, okay, ok!
@nabiaakter845
@nabiaakter845 8 жыл бұрын
okay ookay
@varun5413
@varun5413 8 жыл бұрын
ok ok ok oko oko okooooooooooookkkkkkkkkkkkkkkk
@bjorkenne
@bjorkenne 7 жыл бұрын
what happens with this guy voice? Jesus, I just stopped watching the video.
@PhaniKatakam
@PhaniKatakam 7 жыл бұрын
Amazing subject explained by the guy, what did you listen crook? start focusing on Life and subject in this video... else you would hear only fillers..you are one waste of creator's magic!
Dimensional Modeling
53:54
Bryan Cafferky
Рет қаралды 171 М.
ETL Architecture In-Depth - Advanced Dimensional Modelling
1:07:49
Friends make memories together part 2  | Trà Đặng #short #bestfriend #bff #tiktok
00:18
😜 #aminkavitaminka #aminokka #аминкавитаминка
00:14
Аминка Витаминка
Рет қаралды 3 МЛН
Who's spending her birthday with Harley Quinn on halloween?#Harley Quinn #joker
01:00
Harley Quinn with the Joker
Рет қаралды 21 МЛН
Database vs Data Warehouse vs Data Lake | What is the Difference?
5:22
Alex The Analyst
Рет қаралды 817 М.
Datawarehouse Concepts | Dimensional loading | OBIEE | SCD'S
1:22:58
h2askills appletech
Рет қаралды 28 М.
What is ETL | What is Data Warehouse | OLTP vs OLAP
8:07
codebasics
Рет қаралды 426 М.
What is a Dimension, Fact and SCD?
26:43
IDWBI
Рет қаралды 95 М.
ETL Architecture in Depth - Intermediate Dimensional Modelling
1:09:58
Designing Your Data Warehouse from the Ground Up
1:01:21
Pragmatic Works
Рет қаралды 155 М.
Data Warehousing - An Overview
8:53
Dr. Andy Wicks
Рет қаралды 497 М.