BUSINESS REQUIREMENT: Suppose a bank wants to create a summary report of the overall transactions of the customers. This summary report will help to gather the facts quickly.So transaction reports are made for the customers, both month and year wise. CHALLENGES: The transaction data has to be aggregated in a single table at two levels:
Category Archives: Informatica
BUSINESS REQUIREMENT: Suppose that we are trying to keep the Customers address information. For that we need the mentioned address as well as the geographical location of that place. A geographic dimension is already created which has to be populated first. The geographical information is a normalized structure whereas the dimension is a denormalized table.