DSXchange

For one of the table, i tried with modulo partition (enable partition read-column name) , but seems like all the records are going into each partition. as if it doing entire partition. for example -- if my source table has 5 records the output link shows 20 records As I am using a 4 node cofig file....

Hi, I have a ODBC connector stage with with which i am reading data from a DB2 table. Table has multi million data. When reading data from the table the number of rows is very low, it starts with 1000 and goes up to 7000. Is there a way we can increase the performance of the ODBC connector stage. ? ...

Hi, Somehow I manage to find a solution to this issue as of now, Looks like it is working now, (not sure how it will work in future). What I did is, I use two convert function one after another, in first convert function I replace all my valid charecter with blank, so after first convert I left with...

Hi My job reads data form a DB2 table and writes to Oracle table. A column in my DB2 table is of character type and NEL (special char) is one of he character in the string for few rows, because of this character the string breaks in to two line and I can write this to my oracle table. Hence my job i...

Thanks Craig I understand..you have suggested a mathematical formula to match the count between record from source to record to target. I my case, as I also have a delete link along with the update and insert, so for me the formula is Insert count+update count+delete count-update count=Insert count+...

Hi All, This is a scd2 implementation job and I want capturing number of records inserted and updated to my target. We have two separate links to Oracle connecter stage (one for insert and one for update). In the current audit capturing process we are reading the count from stage_name.link_name from...

Hi, I have asked some what similar question to my client, I am looking for a dummy table where i can insert a record (which does not have any business impact) and as you have suggested I will execute the merge in the After SQl part and in the actual SQL i will execute the insert into dummy table. Re...

Thanks Craig,

I think I can not add the merge to the after SQL statement, because this my first statement in the procedure.

Regards

Hi, I have to convert a oracle stored procedure to DataStage job. In procedure their is merge statement. I have tried with oracle connector stage (with insert and update mode) but the job failed with error " is of incorrect type. The required statement type is: INSERT .........." Is there ...

Dear Guru's, Please share your suggestions.
Please let me know if you need any input from my side.

Regards
Manoj

I have gone through the old post on this error message, I force compile the job, rename the transformer stage but the error is same. Few Input that may help you. command to create the .o file /opt/SUNWspro/bin/CC -dalign -O -PIC -library=iostream -c -xarch=v9 /unit/sys/IS91/IBM/Infoserver/PXEngine/l...

I copied the pxEreplace.o to my PXEngine/lib directory (/unit/sys/IS91/IBM/Infoserver/PXEngine/lib) And after setting the parallel routine properties I have called the rountine from a transformer pxEreplace(lnkReadInvRel.InvestmentID, ".OLD", "", 1,0). The job aborted with below ...

That is not happening. Not able to locate PXEngine/lib. Is there any command that will help me to find path?

It was not intention to say, sorry for that.
No the period can happen any where in the string, like I have mention below.

06053FDL7.X.OLD -- period is there in font of X and OLD. And the output should be 06053FDL7.X and it is happening.

Please check my last post

Hi, I am trying to implement something like this for the first time, and need help from you. I have taken the latest code by Phil Hibbs. Then as per below instruction I follow. 1. Copy the source code to a file pxEreplace.cpp into my home directory 2. Run below command /opt/SUNWspro/bin/CC -dalign -...