DSXchange

Any thoughts on below error?? APT_CombinedOperatorController,0: Current heap size: 1,595,049,352 bytes in 66,276,970 blocks BC_Enterprise_6,0: Failure during execution of operator logic. ODBC_Enterprise_6,0: Input 0 consumed 1616342 records. APT_CombinedOperatorController,0: Fatal Error: Throwing ex...

Sorry I did not get it??

I am having the similar issue on Px 7.5.2.
Anyone has solution for this??

This works great..

Thanks for your help.

I am reading the oracle database for the number field and its recognizing as Integer datatype. My target data type is "int" and how do i convert that datatype??

Thanks

Adding the stage variable and increment by one, works fine with one node. It does not work with multiple nodes.

Can you be more specific on this solution. Sorry about that.

I cant use surrogate key stage either as there is restrction. Let me explain the scenario in detail. I have to move the data from source table to destination table on following condition. Compare the IDNT field on source and target. if matches then do a update . if not, get a maxvalue key from diffe...

Hi ArndW,

Yes, we have restriction at the site. I am not able find any posting on this issue. Any alternates, I am using 7.5 PX on AIX.

Hi,

We are using Oracle database. we can not implement sequence in database. We need datastage to create the keys.
Can you give me more details on using the builtin key management routines.

Thanks

Hi,

Can someone help me on reading max_key from one table and increment by 1 to every row , and insert in the target table. After the increment i neeed to update the max_key value.