DSXchange

Hi Bala, What is the status of RCP on the input of the dataset stage? If RCP is on, Try this: Switch off RCP at the output of the previous stage. Delete the dataset and execute the job again.. Check the data in the dataset through the dataset management tool. You should have only 8 columns of data i...

Try <a href="viewtopic.php?t=85702&postdays=0&postor ... 0">this</a> one..

It details a server solution.. but it will work in a parallel Transformer too.

Hi Ravij, this part of the posted error message has a clue: There are irreconcilable constraints on the number of partitions of an operator: parallel Sur_Key_For_Same_Partition. The number of partitions is already constrained to 2, but an eSame partitioned input virtual dataset produced by sequentia...

A variation of something I'd suggested <a href="http://www.dsxchange.com/viewtopic.php?t=96347">before</a>: After-------- | | ---->CDC-------- | (Delete) | Before-----> Copy------------->Join--- with the same disclaimer: It sucks and destroys all performance. Also another :idea: (either th...

Are the IDocs being loaded to SAP as a single transaction or are they being broken up into multiple transactions?

I vaguely recall a setting somewhere in the IDOc Load Stage that allows for setting the ?transaction? size...

Perhaps playing with this setting would help...

Just pick the first six non-space characters(not just the first word, the entire name):

"c:\documents and settings\admin\my documents"
becomes:
"c:\docume~1\admin\mydocu~1"

As far as the windows OS is concerned, the alternative way to handle long file names are:

use the first 6 non-whitespace characters with a ~1( or ~2 and so on if multiple folders qualify).

e.g. "c:\Program Files"
becomes:
"c:\progra~1"

hth

The randomness witnessed is because your target stage reads data from all(5 ?) nodes and writes the data sequentially in the order it receives it from those nodes. It does not sort the data. As stated by Ray above, the keys will be unique. The round robin partitioning will minimize gaps but will not...

From what i could figure out from the subject/replies... Requirement: How do I do Incremental loads? Source:Sequential file Target: Oracle database. Update frequency: daily Questions that need to be answered: How is the sequential file created? Is a new file every cycle containing the changed/update...

The APT_CombinedOperatorController error/warning usually happens in a Transformer stage and usually has something to do with passing null values to functions.

PX Functions do not like null values.

This happens when there is no matching row found in the hashed file for any input stream row. No row was fetched from the Hashed file for your run.

Nothing wrong in that.

Except if that is not what was expected (Rows should have matched!!!).

IVR,0: Warning: IVR: [DataDirect][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ':'. INSERT INTO IVRPolicyDataMart.dbo.Policy (SourceSystemId,PolicyId,PolicyEffectiveDate,PolicyName,Company,LineOfBusiness,PolicyStatus,PolicyIssueState,PolicyAddressZip,CreateDate,LastUpdateDate) V...

Try:
viewtopic.php?t=90670&highlight=did+not+finish+OK

Hi Rod, What version of DataStage are you using? Is it 7.5 and above? The Sequence can be designed as: Job Activity1----------->Routine Activity-------------->Job Activity2 [This Job Writes the [This routine reads [Add a new Job parameter Parameter to file] the value written by Job1 to this Jobs des...

BCAPP wrote: I have handled the Null condition for all the derivations in the Transformer.

Hi Bhavana,

As far as I remember, the PX transformer is very Null-Intolerant.

Have you tried using NullToEmpty(lnkRecsOut.rightRec_BRANCH_NUM) in the constraints derivations?