1.Zero Iteration count error:
While you are using a variable/parameter at session level which is not defined at mapping level you will get this error.
Resolution:
Define that parameter or variable at mapping.
2.Variable not in the selected list. Whenever you use sql override query the selected columns from the query must be in the same order you define in the source qualifier.If the selected column is not present in the source qualifier or the columns list are not in the order you will get this error.
2.Variable not in the selected list. Whenever you use sql override query the selected columns from the query must be in the same order you define in the source qualifier.If the selected column is not present in the source qualifier or the columns list are not in the order you will get this error.
