Database Reference
In-Depth Information
Informatica shows you the default query based on the links connected from the Source
Qualifier transformation.
In the preceding screenshot, the
WHERE
clause in the SQL query (
WHERE
EMPLOYEES.EMPLOYEE_ID = EMPLOYEES.MANAGER_ID
) signifies the self-refer-
ential integrity of the table. That means that every manager needs to be an employee.
