DB2 Connector Vs Usage of different stages
Posted: Fri Oct 26, 2012 6:56 am
Hi All,
Seek your thoughts on a design. I am trying to retire a MF Extract process which extracts data from DB2 table based on some inner joins with other tables & 12/13 datatype conversions (like CHAR(COALESCE(T.fieldname,' '),7) for a set of fields.
Can you pls let me know whether I can put the same query in a DB2 connector & pull the data (or) is it better to put this logic outside of DB2 connector. (I mean pull the records based on a set of WHERE clause & do the Joins/datatype conversions using other stages.
Any thoughts will be very helpful.
Thanks,
Freddie
Seek your thoughts on a design. I am trying to retire a MF Extract process which extracts data from DB2 table based on some inner joins with other tables & 12/13 datatype conversions (like CHAR(COALESCE(T.fieldname,' '),7) for a set of fields.
Can you pls let me know whether I can put the same query in a DB2 connector & pull the data (or) is it better to put this logic outside of DB2 connector. (I mean pull the records based on a set of WHERE clause & do the Joins/datatype conversions using other stages.
Any thoughts will be very helpful.
Thanks,
Freddie