'SQL Override error in Informatica Pushdown : Column Name list has less columns than Select

I am getting following error while running session in informatica. I am using Query in SQL Override and I have checked it has same number of columns as the defined in source definition and qualifier. Can anyone suggest possible solutions?

(-3706)Syntax error: Column name list shorter than select list., SQLSTATE [37000]

informatica


Solution 1:[1]

  1. Try not to use query override, if possible.
  2. Run the mapping without override. Verify the result.
  3. GENERATE the SQL statement and run the mapping. Verify the result.
  4. Compare the generated query against your own.
  5. Verify the links going OUT from Source Qualifier.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Maciejg

Related Questions