DSXchange

Hi ,

Are you sorting using the Inlink sort in the joiner stage,If so you may get this error.

Try using the explicit sort stage and use the " same Partiton" in the joiner stage .

Even after that if you are getting the error then contact your ETL admin...

Hi ,

Are you sorting using the Inlink sort in the joiner stage,If so you may get this error.

Try using the explicit sort stage and use the " same Partiton" in the joiner stage .

Even after that if you are getting the error then contact your ETL admin...

Hi Jassu, Please check on what keys the table you are trying to delete is partitoned. If suppose the the table is partiotned on colA and ColB ,Then try using the below query in your DB2 Enterprise stage: "DELETE FROM <TABLE_NAME> WHERE <COLUMN_NAME>=VALUE OR COLA=-1 OR COLB=-1". If the tab...

I have three files named fileA.txt,FileB.txt,FileC.txt I want to read all the files at a time and process them into the other table. In The Properties Tab Under Source :- FILEPATTREN :- C:\DXFILES\File?.txt READMETHOD :- filePattren . But i am not able to read all the three files . What would be th...

Hi Balaji.. It worked fine with single node. Re-creating the jobs to check if something has missed out. Is there any other method to find the issue? Hi, I am facing the same issue with CDC(Change data capture) stage ...Each time when i run i am getting different Output while using 4 node con fig fi...

Hi, I have tried the job regarding transformer null handling like to create a transfomer reject link,right click on on an output link and choose "convert to reject" but i didn't get the colums having null values in the reject link.Can any one tell how to get the colums having null values ...