Airline code changes and mergers: keeping your data current
Vistara, Alitalia, Virgin America: what really changes in airline data when airlines merge or shut down, and how to handle it.
Vistara, Alitalia, Virgin America: what really changes in airline data when airlines merge or shut down, and how to handle it.
JFK, NYC, KJFK: why one airport has several codes and names, which systems use which, and how to keep them in sync.
Some IATA airline codes belong to two airlines at once, and codes get reused. Here is why, what breaks, and a data model that handles it.