DSXchange

Thank you for you suggestions Ray and Althaf.

But what is the difference between the ODBC Connector and ODBC Enterprise stage in v.8. Both seem to allow option to updates.

Hi, I've just started a new project for a client using DataStage v8.0, using Netezza as the target databse. I am new to Netezza, but apprantly they are unable to update an exisitng row in a Netezza table. I've searched the documentation, I can only see Append, Create, Replace and Truncate options. A...

Hi Maveric, Thanks for your response, I am looking up both these fields nad trying to output the cont_id from teh referecne link with in the lookup stage. So now where ever there is a mismatch it should return Null to the cont_id,but instead it returns '0'. The field cont_id is nullable. Regards, Sa...

Hi, I am trying to lookup a decimal value (e.g.SQR_CTR_ID) with an integer field (Cont_id) from the target table using a Lookup stage. I am continuing even though the look-up fails. Our undertanding is that if the lookup fails than cond_id (from the lookup table) should be set to null. But at presen...

Hi All,

I have a Parallel job where in I need to perform a join using join stage based on the Key values with different Column Names..

Eg: Emp_id with Manager_id

Can I perform the join on these fields in a join stage?

Rgds,
Hitesh