DSXchange

My parallel job populating warnings even after setup to suppress warnings as info by message handler. When I see the project level message handler setup, I noticed it has two similar entries for same warning message. Message handler looks like. IIS-DSEE-TFSF-XXXXX 1 Span for padding a substring must...

Hi,

In Hashfile stage it shows preload file to memory- Enabled and disable etc.

Which thing is used to increase the performance in hash file stage?

Hi

I have faced the 'Parse error on case string: 000=0,001=1
multiple `=' tokens were seen' error when i am using switch stage. please help me to resolve this error.

Thanks in advance

THANKS A LOT

Hi
MY job aborted due to the reason of "The current soft limit on the data segment (heap) size is less than the hard limit, consider increasing the heap size limit"

where(how) i can handle this.

METADATA PROBLEM IN OUPUT COLUMNS

i have used two sequential files are my input and made full outer join and transformer and target also a seq file... while run this i got error like "Error when checking operator: Export validation failed. "... please provide some details

my input rows are 122843. and fisrt(input) stage--then transform stage-- then output(seqfile) stage.
in my output i am getting 119925 records. within this 24 rows are not satisfying my filter condition. 0 rows are Otherwise/Log output link

my input rows are 122843. and fisrt(input) stage--then transform stage-- then output(seqfile) stage.
in my output i am getting 119925 records. within this 24 rows are not satisfying my filter condition. 0 rows are Otherwise/Log output link

i could not comprehend your reply. please let me come once again

I have a seq file with the input colums of ZIP_END_DT_DEF,MBR_ADR_ROW_EFF_DT,ZIP_EFF_DT_DEF,MBR_ADR_ROW_END_DT. while i am checking the condition (ZIP_END_DT_DEF>=MBR_ADR_ROW_EFF_DT) And (ZIP_EFF_DT_DEF<=MBR_ADR_ROW_END_DT). i am getting 119925 output rows. but my expected output rows are 119813. si...

hi i am doing if...then ...else condition in transformer's column derivation. and the o/p should write in to a seq file. in this i am getting the error "buffer(3),0: Fatal Error: waitForWriteSignal(): Premature EOF on node apsp8493 Permission denied"... Even i have all enough permission to...

mcs_murali83 wrote:Hai,

One of u r column contains the varchar as its datatype. But you want to extract the numeric values.

There is an option in transformer stage, goto functions----->
As integer(columnname)

murali
As integer is used to convert in to integer data type

[quote="Maveric"]If it is only "," then you can use the trim function. Not sure of the options but i think 'A' removes all occurences. Trim(In.Col,',','A')[/quote hi In my sample data 35064,35884,1.. here 35064 is coming in a row and viz versa. i hope you meant all in a single ro...

kishore2456 wrote:What type of input is it exactly? It will be easier if you can post some sample data. Is it a mix of char & numerics?

Actually input field is varchar (10) and it contains julian date... now it have only numeric values.
ex: 35064,35884,1,