When you run an Informatica workflow and you get the following error message
ORA-24333: zero iteration count Database driver error... Function Name : Execute SQL Stmt : TABLE_NAME.COL1='A' Oracle Fatal Error Database driver error... Function Name : Execute SQL Stmt TABLE_NAME.COL1='A' Oracle Fatal Error].
The Informatica error description in https://kb.informatica.com/solution/18/Pages/121171.aspx say
” This error occurs because the SQL query sent to the database for the Source Qualifier only contains the Join statement – this is caused by putting the JOIN-statement in the SQL Query property instead of in the User Defined Join property of the Source Qualifier.”
This is a little confusing because the message talks about joins when in many cases, like the above example, there is no join.
Still the problem is the same and all you need to do is to move the query from the SQL QUERY to the USER DEFINED JOIN section