Thursday, May 27, 2010

Informatica: Error when validating source qualifier query

Error: Query should return exactly 3 field(s) to match field(s) projected from the Source Qualifier.

Issue Description: When validating a source qualifier query, the message "Query should return exactly 3 field(s) to match field(s) projected from the Source Qualifier." appears.

Issue Resolution:
(1) Ensure that the query is returning the same number of columns as there are ports in the source qualifier.
(2) Ensure that data is being fed to all the ports in the source qualifier. That is ensure that all the ports are connected.
(3) Ensure that data is going out from all the ports of the source qualifier. Again, ensure that all the ports are connected.

No comments:

Post a Comment