CODEWITHSUNDEEP
informatica
adan
adan

Reputation: 21

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]

Upvotes: 1

Views: 487

Answers (1)

Maciejg
Maciejg

Reputation: 3353

  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.

Upvotes: 0

Related Questions