A single child table in a data warehouse containing potentially repetitive information, surrounded by parent tables (dimension tables) that are used to provide keyed retrievals of unique rows from the child table;
The main table in a star schema containing metrics used for aggregations and codes that are linked to dimension tables, used to access descriptive information for the codes.
File DSN
in ODBC, a file level data source name.
Flat file
A file structure where data items are stored line by line in a two- dimensional array.