DSXchange

Is there any difference between a single quote to a double quote when defining a value in parallel job transformer stage? I am trying to do null handling for a lookup value by assigning it to '-1 ' which has a space character in the string, but the records always get rejected while loading due to th...

I don't know what has fixed the issue, but now its not coming after I changed the prefetch rows to a smaller value of 100 from 2000.

Kryt0n wrote:Reverse the order so that the oldest record is last, then use stage variables to hold the newer time.

Thanks, Yes this is what I did exactly. I ordered in desc order and then processed using stage variables.

I am getting this error. I have not found any entry for such. Has anyone come across this type of error before and if so, how to resolve it? DB2_TISUITE_WORK,0: Invalid timestamp value in setOutputFieldAsTimeStamp() for field '184' in output dataset '0'. Time stamp string = 0000-00-00 00:00:00.00000...

I have a peculiar scenario. I want to capture the Time taken between two transactions and assign the elapsed time to the first transaction record. I could do this but assign to the next transaction instead of the first one. So if anyone can tell if the other way is possible? Please find the attached...

I am trying to get the start time for a given job by running this command in a shell script. JOB_STARTDATE=`${BinFileDirectory}/dsjob -jobinfo $PROJECT $DSJOB|grep 'Job Start Time'|cut -d":" -f2` echo $JOB_STARTDATE The output is Status code = 0 Mon Apr 25 10 How do I avoid gettting the St...

I have encountered a weird issue, using Userdefined SQL in Oracle db stage, if the sql size is 11kb then the job fails with the error: The provided query statement did not prepare correctly; So I removed all the whitespace in the query and got it to 9KB and then it works fine. So does that mean we w...

Hello, I am getting the below error in Production. Can you help me understand where to look for this parameter? Has anyone come across this type of error? The job is simply loading incremental data from source to staging using change data capture. This is a repeated error every week but is not limit...

Hello, I was wondering if there is a way to specify Null Handling and a type conversion together in a single Specification for Modify operators. If so can anyone share the syntax? I have the following as the current specification: CANCELLATION_DT=date_from_timestamp(CANCELLATION_DT) I want to add th...

My 2 cents, Does Open Command and Close Command option work for you? Worth giving a try.

I am also currently facing the same issue. Was this resolved? In my case,I sat down with our Administrator and trying to create a Project in Information Console, but cannot see the New Project button highlighted. We checked the roles in the web console. The admin has the Suite Administrator role and...

Yes the SQL Server is of low configuration. It is a virtual server and having only 2 nodes with 2 GB of Memory. The DBA increased the CPU on that virtual server and added 2 more GB on that(Windows server 2003 - Standard edition). There are no updates, the job just loads the staging table. And the ta...

The target is SQL Server 2005/2008. According to Ray's comments, if we give the column names in ""(Quotes), then it must work? Am I right?

Dear DataStagers, I have a simple job which is doing a Extract and Load. The stages in the job are DRS -> Transformer -> SQL Server Enterprise. The performance is not that great. I see a extract row count/sec of 4000 initially and then drops down to 200 after a while. Also the SQL server is so overl...

Hello DataStage'rs, I have a requirement to name a column as HCFA-UPIN. I cannot do that as the Transformer stage wont allow that name and suggests that names cannot have special characters other than underscore(_). I can convey that to Business and they may probably agree, but wondering if there is...