📝 One-liners · 66 cards
DATA WAREHOUSING AND DATA MINING
What is a Data Warehouse in the context of banking?
A Data Warehouse is a large, centralized repository that integrates data from multiple banking sources (core banking, ATM, internet banking) to support management reporting, analytics, and decision-making.
What is 'data scrubbing' in the ETL process of a Data Warehouse?
Removing errors and inconsistencies from source data before loading.
How does a Data Warehouse differ from an operational database in a bank?
Operational databases handle day-to-day transactions (OLTP) and are optimized for fast writes, while a Data Warehouse is optimized for complex queries and historical analysis (OLAP) across large datasets.
What is 'slice and dice' in OLAP analysis?
Selecting and viewing specific data subsets across multiple dimensions.
🔒
Unlock 66 revision one-liners
Interactive flashcard deck — flip every card to drill questions and answers, mark the ones you got wrong, and revise smarter for DATA WAREHOUSING AND DATA MINING.
🪙
Unlock cost
300 coins
30-day access · re-unlocks free for 30 days