Saturday, November 17, 2007

Generate a default query

A user finds that she is unable to generate a default query in the Source Qualifier SQL Editor. What is a possible reason for that?

Choose Answer

The datatypes in the Source Qualifier do not match the corresponding datatypes in the source definition(s) for each field and port.
The Source Qualifier does not have one or more ports connected to another transformation or target in the mapping.
The Source Qualifier property "Allow default query" is unchecked (set to false).
The Source Qualifier is not connected to the source database.