DB2 Connector Vs Usage of different stages

[DSFreddie]

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

[priyadarshikunal]

In this scenario, my answer will be, It depends.

I would check multiple things before reaching to a conclusion such as:

What will be the complexity of the query?
Does it has an easier and more efficient way of doing it datastage?
Based on infrastructure where I can put more load, DataBase or DataStage?
etc