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
DB2 Connector Vs Usage of different stages
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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
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
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.