BDW q on trans in a bank

[chvenkat.v]

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.

[DSguru2B]

First of all that would be a transactional system and not a warehouse. Now the business needs to define the rules as to what transaction types need to be captured. They might come back and say, We need a cumulative record for all withdrawls and a cumulative record for all deposits, or they might just say, we just need the balance.
You need to get the requirements in place first.

[ray.wurlod]

Ask IBM about their Change Detection software, which scrapes this information from the transaction logs.

Please avoid abstruse abbreviations, such as "BDW" and "q", which make it more difficult for those whose first language is not English.