INSIGHTCLOPEDIA

Contributions welcome!

F

Fact table

A central table in a data warehouse schema that contains measured values and keys that specify the relationships between facts and dimensions. Fact tables contain data that describe specific facts within an organization, such as the underlying values of transactions, payments, sales, etc. A fact table contains the facts (measures) of a business process or an event: Usually numeric (number, …

Factless fact table

A fact table that does not contain values.

File transfer protocol (FTP)

A protocol and service that makes it possible to transfer files from one computer to another over the Internet. A protocol that dates back to the very early days of the Internet, but is still widely used to exchange data files.

Financial accounting standards board

Founded in 1973, its mission is to define and constantly improve standards for financial accounting and reporting.

Financial accounting standards board (FASB

Founded in 1973, its mission is to define and constantly improve standards for financial accounting and reporting.

Flat file

File with data in text format. For example, an accessible source from a production database.

Foreign key

Key used in tables in a relational database to refer to the unique key of a table with which a relationship exists.

Foreign key (FK)

Key used in tables in a relational database to refer to the unique key of a table with which a relationship exists.

Frequency of update

The frontend of an application. The part that the user comes into contact with

Functional datawarehouse

A data warehouse that specifically serves to provide a certain functional group with BI. For example for one specific department or location.