DSXchange

Thank you all for the inputs. I'll see if I find any books that puts out restrictions. I did look into EOW (end of wave) markers so I'm using ODBC stage which has an option to emit those waves or not and I've disabled that so that it does not interfere with main data and its EOW markers. I do not kn...

We have a CDC parallel job running in continuous mirroring mode. We are using join stage to lookup extra information. The join stage pulls the data from the referenced table correctly for the first time. But for subsequent records, it does not pull anything from the referenced table. So with inner j...

No reply from anybody? Let me rephrase my question.
What is the best practice for handling errors in CDC parallel job?

I'm going to have 2 always running CDC parallel jobs for real time ETL. I would like to get some inputs from members on apart from reject links, are there any other error handling functionalities available in the parallel jobs which would accomplish - 1. The job should not crash and should always st...

I was able to fix these errors by reducing the xml column widths and reducing the size on following of job parameters.
$APT_DEFAULT_TRANSPORT_BLOCK_SIZE and $APT_MAX_TRANSPORT_BLOCK_SIZE.

Thank you again. I meant what are my options if I'm running out of memory?

Thank you.
How do I disable operator combination?
what are my options here?

I'm using lot of xml input stages in a parallel job. Currently I've 4 xml input stages but when I add 5th xmlinput stage, I get following error: _CombinedOperatorController(1),0: Caught exception from runLocally(): APT_BadAlloc: Heap allocation failed.. APT_CombinedOperatorController(1),0: The runLo...

Thanks a lot! You are a lifesaver. Why is this feature not documented anywhere?

I'm using XML_Input stage.

Hello, I'm new DataStage. I'm trying to figure out how can I get input columns that are not xml as part of output columns. Take the following scenario - Input has 2 columns - Key and SourceXML. SourceXml produces ~20 columns in the output. But I also want Key to be as output column. Is there anyway ...