DSXchange

Hi, While I am testing my jobs in latest version 11.3 I got below error ..In version 8.5 job is running fine (I am using same data file ) seqfile >>>xfm >>>ds APT_CombinedOperatorController,xx: External string too long. Imported only 100 out of 125 external characters. Ignoring last 25 characters up...

In Current version 8.5 ,we selected Batch size "10000" Below is the log SFDC_Test,0: Sent 10,000 records to Salesforce SFDC_Test,0: Information: Wait for: 30 seconds SFDC_Test,0: This batch 1 completed SFDC_Test,0: This batch 2 completed SFDC_Test,0: Loading finished. 212,233 rows are load...

Recently we installed Version 1.5 for 11.3 in Unix While Testing our jobs we found that In Director log ,there is no information about the record counts (for successful runs also) SFDC_Test,0: <No message available> @rkashyap , Were you able to figure out the issue while discussing with IBM support ...

Hi Ray, In the Remove duplicate stage ,I used EMP_NO,EMP_TYPE as keys and performed hash partition on these keys and choose option to Duplicate to Retain 'Last' and SET EMP_STATUS "NEED LOGIC " I was able to get these 2 records out Emp_HistID |Emp_NO|EMP_TYPE| EMP_STATUS 100*7 100 H NEED L...

Hi, I have the following requirement that I am working on to implement the solution Input Emp_HistID| Emp_NO|EMP_TYPE 100*1 100 H 100*2 100 RH 100*3 100 H 100*4 100 R 100*5 100 R 100*6 100 RH 100*7 100 H 100*8 100 R 100*9 100 V 100*10 100 RH Required output : Emp_HistID |Emp_NO|EMP_TYPE| EMP_STATUS ...

I have a webservice which delete records from a table and the job hangs when it encounters certain records. It just does not do anything from that point. I compared the records for anamolies but couldnt find any compared to the ones that process successfully. I ran it through SOAP UI client and get ...

Very useful information , Thanks to everyone.

ArndW, Thanks for the reply , This answer looks simple but is also why i debate with myself. Considering the Stage variables can be used inside constraints , shouldn't the execution order be dynamic? first Check if a SV is used inside a constraint if yes then process SV before Constraints. And if no...

I know this question is asked many many times , i see 2 answers 1. SV, Constraints, Derivations 2. Constraints , SV, Derivations. I tried for this in IBM documentation and couldn't find it anywhere. I personally feel its SV, Const and Derivations for the reason why process all the SV's for all input...

Thanks for the reply, I am using the same character set in the seq file also , i tried textpad , notepad++ and Ultra edit all of them show the same issue

I am using oracle connector to extract data, using the NLS mapping specified by the database owner (ASCL_ISO8859-15). When i do a view data in the oracle connector stage the data looks fine , but when i open the text file after extracting the data looks messed up eg(Funcionário1). Could anyone th...

@Chulett, Draft Design : Start Loop <----------------------- End Loop | | | | uv_activity ---------------------------Exec_Activity In uv_activities define variables like below uv_timestamp time_stamp logic uv_file1 filename1 uv_file2 filename2 ..so on Exec_Activity cp sourcedir uv_file1.txt target d...

There is no wildcard pattern ..Each file is generated by individual job. 1.Alternative I can think is having a seperate link for each file UV -->Execute activity (file1) UV -->Execute activity (file2) UV -->Execute activity (file3) 2.Looping ?Can I implement this way? Start loop -->Read file1 -->gen...

Hi, I have the following requirement and I need input for designing of my job copy multiple files from source to target directory with timestamp added to the Filename. Current design to copy single file in a sequence UserVariable_Activity (Generate timestamp)----> Execute Command Activity (cp source...

Hi , I am getting the following error while updating data in SQL server database using ODBC connector stage UPDATE SCHEMA.TABLE SET EMP = ORCHESTRATE.EMP , COLC = 'N' WHERE EMP = 1 AND COLA = ORCHESTRATE.COLA AND COLB = ORCHESTRATE.COLB AND COLC = ORCHESTRATE.COLC Warning message : TABLE: Unable to ...