This is how the explanation should be precise and very clear.I have seen so many videos but most of the presenters present in a confusion manner whereas this video is very clear and very simple. Great work and all the best.
@saikatpal8996
4 жыл бұрын
So simply explained but yet so informative.. You are Lionel Messi of bw4hana..
@kiranmainamala9508
3 жыл бұрын
Very well explained sir.Hope to see more videos on SAP BW4 HANA concepts.
@vasanth678
3 жыл бұрын
Beautifully explained and simple.., thanks
@Muhammad_Fakier
Жыл бұрын
Well done on explaining this! Superb. So much insight on this now -thanks!
@shakthiramalaxmi5377
4 жыл бұрын
Such a clear information. Thank you so much!!
@faisalmahmood5278
3 жыл бұрын
Excellent job! Thank you for sharing Debanshu .
@gurudattb
3 жыл бұрын
Thank u sir .. for that such great explaination ....
@reddipraveen9004
3 жыл бұрын
Well explained sir. Thanks for ur time and this video
@igormelin4023
Жыл бұрын
Very good explanation!
@Letucenick
Жыл бұрын
Thank you!
@arifmiyan4105
3 жыл бұрын
Very well explained sir. Hope to see more videos on SAP BW4 HANA concepts. Actually sir, I am looking for SAp BW on HANA, SAp BI ABAP, SQL using in BW.. Plz if possible upload all these videos thank you
@salehaperveen1182
3 жыл бұрын
Good explanation.. Thank you sir.
@dearzindagi9170
3 жыл бұрын
Great explanations 👍🏽 thanks
@AjayKumar-mm7fh
3 жыл бұрын
Why do we need to load data twice from source..even if we load from staging layer to next level ADSO, it still serves the purpose of corporate layer, rebuilding the data in future if needed...this also avoids loading from source..loading from transactional system may not be the better option when compared to loading from staging to reporting layer ADSO..pls clarify..and thank you very much for all your videos..very much helpful😊
@rda103
3 жыл бұрын
Perfect!! Loved it :) Thanks alot
@ErdemPekcan
4 жыл бұрын
If that "dotted" line is not used in daily flow, you should have two seperate delta mechanism running with two DTPs. Even if it's a full load, why bother to get the same data from source two times?
@balakrishnakatha8000
4 жыл бұрын
This is the modification that I am using in the design. We should avoid extracting the same data twice from the source to reduce load on source. Before ODP, since we have PSA, it make sense to extract data into PSA first and then do a parallel load to corporate memory and data propagation layer. If we are using ODP we can first load to staging to fetch data from source once and then to propagation layer. Another way to think if we want to fetch same data twice from the source, only pro I see is reducing batch time. We need to check both options based on our requirements.
@ErdemPekcan
4 жыл бұрын
@@balakrishnakatha8000 I've never seen a requirement for loading the same data twice. Even there's a case, that should be very very rare. I think SAP designed this concept as two options. Either from Source->CM->DWH or from Source->DWH. Not simultaneously Source->CM & Source->DWH.
@DebanshuMukherjee
4 жыл бұрын
@@ErdemPekcan The parallel load to staging ADSO is to store data in the source format 1:1 without any transformations. This staging ADSO is not used in daily flow but rather to support rebuilding scenarios meaning when there's an issue in the data consistency which requires us to load an entire year data or entire plant/material group data from source, now you don't need to put any burden on source but rather get the data from the staging layer ADSO. That's the main purpose of the staging ADSO. And yes, although data is stored twice but plz keep in mind that granularity is not usually the same meaning in staging ADSO, it'll be same grain as source but in Stnd or Datamart ADSO the grain is higher and matches the requirement. Additionally, please keep in mind that ADSO tables are column tables meaning huge compression takes place (~80%) so that too helps to keep memory in check.
@ErdemPekcan
4 жыл бұрын
@@DebanshuMukherjee sorry but my point and explanation was not about the purpose of CM and DWH layers. It was all about data loading concept.
Пікірлер: 22