DSXchange

Thanks Mike, definitely i can use this. But i want to calculate it from the backward. so, i think i should store the delimiter count in a variable and then use the variable in the field function. i think whatever you have given will give me the value after the first space. but i want to take the val...

Hi I want to capture the value in a field after the last space. It is a name field and i have to capture the last word after the last space. Since the spaces are dynamic..i.e every record has a different name, i am not sure , how this can be captured. For example, the the billing name is Jo Smith Jo...

The first aggregator was showing as collection type because it was in sequential mode. I made it to parallel and partitioned in round robin. The second aggregator is in sequential mode. But it is not giving correct output.

i made the first aggregaor as round robin and next as sequential mode. But the output is not correct.

The first aggregator shows as a collection type.

sima and sjaladurgam So, the two aggregator stages would not hinder the performance while doing for millions of records???. i am just worried since the data is very huge..anyway, thanks for your input. Ray, i am not sure how we can calculate while actual processing, because anyways i have to calcula...

Hi,

I searched dsxchange and accordingly changed the $APT_STRING_PADCHAR to value as 0x0 and the job completed fine. I dont know the root cause though.

Hi, We are running a job where in the target there is an udpate statement UPDATE #$Prm_Db_AcctHist_Table# SET AH_CLS_UPD_IND = ORCHESTRATE.AH_CLS_UPD_IND WHERE (AH_ACCT_BTN = ORCHESTRATE.AH_ACCT_BTN AND AH_AFFILIATE_ID = ORCHESTRATE.AH_AFFILIATE_ID) But the job aborted with the following error CV_AC...

I am using an aggregator stage just to count the number of rows from a particular link. The design is like this Seq file-->transformer-->aggregator-->seq file Here i need the aggregator to count the total rows from transformer(the key is same for all the records), so it would pass through only one p...

Thanks..I never thought that we can use other stages also in the reject link:-)

Hi,

I am inserting records to oracle through one link and updating passing the update records through the other link. How can i capture the reject records from oracle. I want to just calculate the number of reject records, but i think i cannot do it with a reject link.

can anyone help.

Great!! It worked..Thanks. I used the 2nd and 3rd points.

Hi,

I have a user defined environment variable in a job. I want to pass that value in a transformer and update it in a file and table.

But the value of that variable is not passes properly and i see that updated as "0".

Can anyone help.

I have 4 date fields in my input which are read from a fixed width file with the format yyyymmdd. Now i want to validate the date and if it is invalid then, i should send it in an error file. Is there a way to use a common function to use for this. Because converting each field to date and then vali...

Is there a function in parallel to validate numbers/numeric?
In sever we have a function Isnum() which validates whether a given value is number. Similarly do we have anything in parallel.

Hi, We have a job which was working fine. it was a straight forward job to load a table with the data from a file. We had given the option as "Truncate", "Load". With a recent change an index was added to the table. After that it is failing with the following error:- Oracle_Enter...