Question

For an airlines company, identify three operational applications that would feed into the data warehouse. What would be the data load and refresh cycles​

Answer 1

Answer:

There are three types of applications, which can be used in data warehouse;

The Reservation Application

The Billing Application

The Claim Application

Explanation:

The Reservation Application deals with priority boarding, seat selection, domestic flight, international flight, travel insurance, hotel reservation and car rental hotel reservation. Similarly, the billing application deals with payment of different cards such as credit card and debit card payments, agent payments, frequent flyer miles redemptions, and billing information. The date load and refresh cycle for this application would be daily. The third application, the claim application is related to different claims such as delayed flight claims, canceled flight claims, downgraded class claims, lost baggage claims, and other customer related claims. The date load and refresh cycle for this application would be weekly.

Answer 2

Answer:

Explanation:

For an airline company, how can strategic information increase the number of frequent flyers? Discuss giving specific details.