An SQL inline view is a SELECT statement in the FROM clause of another SELECT statement. For example, the following SQL includes an inline view:
SELECT ename
FROM (SELECT ename
FROM emp)
You can view data lineage on a database table, view, or synonym used in an SQL query with an inline view. The SQL query can exist in the following objects:
SQL override in a PowerCenter Source Qualifier or Lookup transformation.
Database views, stored procedures, functions, and triggers.
SQL inline views are also referred to as Common Table Expressions.