Informatica Error: ORA-00932: inconsistent datatypes: expected %s got %s

The error is something like this which you can collect from sessionlog.

READER_1_1_1> BLKR_16007 Reader run started.
READER_1_1_1> RR_4029 SQ Instance [SQ_Shortcut_To_table_A] User specified SQL Query [SELECT table_A.field1,table_A.field2, table_A.field3, table_A.field4, table_A.field5, table_A.field6, table_A.field7, table_A.field8, table_A.field9, table_A.field10, table_A.field11, table_A.field12, table_A.field13, table_A.field14, table_A.field15, table_A.field16
FROM Schema_a.table_A
WHERE
table_A.field10 IS NOT NULL AND
table_A.field11 = 'N']
READER_1_1_1> Thu Nov 02 21:37:13 2006
READER_1_1_1> RR_4035 SQL Error [
ORA-00932: inconsistent datatypes: expected %s got %s

Resolution:-Check your SQL qualifier transformation,validate the SQL Query.And then keep on checking other transformations whether any inconsistent data flow is happenning there.In my case I was trying to squeeze records from one port(number(10,2)) of SQL Source Qualifier tranasformation to the target port(decimal(8)) of the Expression Transformation.And hence was the error.

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com