What Is A Derived Table And Why Do You Use It?

1.	What Is A Derived Table And Why Do You Use It?
Answer» A derived table is a virtual table in the data foundation that combines other tables using calculations and functions. You can USE derived tables for below purpose − To CREATE a table with columns from other tables. The COLUMN DEFINITIONS can include complex calculations and functions. To create a single table that combines two or more tables. To create a table that contains a SELECTION of columns from different tables. To Insert Derived table, Select table header → right click → Insert → Derived table. A derived table is a virtual table in the data foundation that combines other tables using calculations and functions. You can use derived tables for below purpose −

Answer»

A derived table is a virtual table in the data foundation that combines other tables using calculations and functions.

You can USE derived tables for below purpose −

To CREATE a table with columns from other tables. The COLUMN DEFINITIONS can include complex calculations and functions.
To create a single table that combines two or more tables.
To create a table that contains a SELECTION of columns from different tables.
To Insert Derived table, Select table header → right click → Insert → Derived table.

A derived table is a virtual table in the data foundation that combines other tables using calculations and functions.

You can use derived tables for below purpose −

Discussion