DSXchange

Here is the entire log Output from transformer compilation follows: ##I TFCN 000001 14:36:21(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.2 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved ##I TUTL 000031 14:36:21(001) <main_program> The open fi...

I cleared the status file,job resources and did force compile but still it doesn't work.This is the error which I am getting "Error compiling parallel transformer".

I have a job named Job1 which is not getting compiled when I try to compile it but when it is renamed as something else like Job1_cp it gets compiled.How to resolve this problem apart from renaming it and compiling it as this job is used in lot of sequence jobs.Changing the job name in all the jobs ...

I have a scenario where in I need to replace integer datatype fields with numeric datatype.I thought to replace it from schema file but in the backend for integer its int32 and for numeric its decimal[p,s].All the fields have different lengths so I can't do that.Is there any way where in we can repl...

I have a scenario where in I need to take DSJobStartDate and find the end date of the previous month.I know how to get the end of the month but how do I go back to the previous month from DSJobStartDate.

I am running into this problem Caught exception from runLocally(): APT_ParseError: Parsing parameters "**********" for conversion "date=date_from_days_since[**********](int32)": APT_Conversion_Date_DaysSince: Invalid Date [**********] used for date_from_days_since type conversion...

It works in Manager using crtl or shift but it doesn't work in Designer.Thanks for the help,appreciate it.

How to select & move multiple jobs from one folder to other folder.

There is a business requirement where in I need to do that.I tried one more option like using iconv in execute command to first convert ascii files to unicode and the concatenate them but it throws an error that it can't open the iconv converter.

When I try to Concatenate two files using cat command. cat a b > c where a is an ascii file and b is an unicode file with spanish characters.If the b file has less data output file "c" is getting created but if the b file has huge data then output file "c" is not getting created ...

I have a scenario where I am reading unicode data from oracle database & writing to a file.This file which contains spanish characters and other unix file is concatenated and written to output file "z" by using the command cat x y > z where y is the unicode file.The output file some ti...

remaining error code if ((notnull(To_Mem_Xfm.PREV_PLAN_ID) && (To_Mem_Xfm.FORMULARY_AVAILABLE_IND == InterVar0_1))) { 1302: To_Lkup_Plan.FRM_SEC_NO = InterVar0_7; 1303: } else { 1304: if ((null(To_Mem_Xfm.PREV_PLAN_ID) && (To_Mem_Xfm.FORMULARY_AVAILABLE_IND == InterVar0_1))) { 1305: ...

sorry it broke off in between this is the remaining compiling error ##W TBLD 000000 10:54:44(384) <main_program> Error when checking composite operator: Output from subprocess: "/usr/local/Ascential/Projects/cs_eob_dev/RT_BP855.O/V0S73_EOB_FileLayout_2008_Job_2_copy_test1_Xfm_Mem.C", line ...

This is the logic I am using in column derivation and its compiling properly.But Before this I implemented it in stage variable & mapped the stage variables to column but I was getting the compilation error. If Trim(inputcol1) = "1234" And Trim(LANGUAGE_CD) = "EN" Then 'S028'...

I am using transformer to perform some transformations & I have created few stage variables.I am doing all the transformations in stage variables and mapping those to columns in column derivation.One of the column when mapped with stage variable in column derivation is not compiling the job by s...