BDW q on trans in a bank
Posted: Wed Feb 25, 2009 8:53 am
Hi all,
I have sample question about banking data warehouse.
One customer came to the bank for one day
Example:
11:00 am x customer opens an a/c in bank
1:00 pm same x customer deposit some amount to his a/c.
4:00 pm same x customer withdrawn some amount from the bank.
7:00 pm again same x customer transfers some amount to his friend a/c y.
How to catch all truncations stored into banking data warehouse.
I have sample question about banking data warehouse.
One customer came to the bank for one day
Example:
11:00 am x customer opens an a/c in bank
1:00 pm same x customer deposit some amount to his a/c.
4:00 pm same x customer withdrawn some amount from the bank.
7:00 pm again same x customer transfers some amount to his friend a/c y.
How to catch all truncations stored into banking data warehouse.