SAP WM (Warehouse Management)
SAP WM (Warehouse Management) Forum
Hello Everyone,Can anyone explain banking project in brief like some examples about what kind of datamart, what tables, load type, objective of the datamart etc.
Thanks in Advance!
In banking domain, below are the key things:1) we have nearly 50+ source systems like finacle,cards,loans.demat etc.2) normally banking people will maintain the salary datamart,internet banking datamart,debitcard datamart etc.3) the tables like general acct master,customer master details,liability accounts,transaction tables etc.4) load type like,insert process,truncate and load,history load,upsert (insert+load)process
Can you please explain about only one datamart in detail. And what schema design it is?
I don't remember exact logic about it. See below may be it is helpful to you.Suppose if we take an example of internet banking datamart, we maintain all the accounts from bank,internet banking active or not,last login time,bill pay reg.or not,last transaction amount,mobile active or not etc. like that we store all fields related to internet banking and use to run incrementally. Normally we follow star schema.
Sign up for STechies