Apparatus and method for relating graphical representations of data tables

A computer readable storage medium storing executable instructions to graphically represent one or more relationships between data source tables, the executable instructions executed by a processor to:

• receive a selection of multiple data source tables from one or more data sources used to populate a data warehouse;
• determine a data source table, from the selection of multiple data source tables, that defines keys;
• receive mapping information that defines one or more column relationships between the data source table and a second data source table from the selection of multiple data source tables;
• analyze relationship structures of the selection of multiple data source tables based on the mapping information;
• determine a longest path from the data source table to one of the selection of multiple data source tables;
• and
• graphically represent the selection of multiple data source tables and the relationship structures in a sequential order, where the sequential order in which the selection of multiple data source tables are depicted is based on the longest path, thereby creating a visualization of dependencies between the multiple data source tables that supply data to the data warehouse.