The XML view [X_A] is projected but it is not reachable from a root view
To resolve this issue, if the view "X_A" has a Hierarchy relationship to the root view or descendants of the root view, make sure that all the appropriate Foreign Key columns are projected.
The following columns exist in the XML Target definition:
When the mapping is validated the following error occurs,
... The XML view [X_SALES] is projected but it is not reachable from a root view.
Since FK_PRODUCT is not projected, PowerCenter is not able to find a path from the root view to the X_SALES view. Projecting the FK_PRODUCT column resolves the issue.
What can we do to improve this information (2000 or fewer characters)