This is an old revision of the document!


F

Full Text Index

fact table

  • 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.

foreign key

  • See child key

Quick Links

 
Back to top
glossary/f.1248356840.txt.gz ยท Last modified: 2012/10/26 14:20 (external edit)