DSXchange

Hi All, I have a date filed coming from Input as Decimal (13,5) Value : 09092008.39699 , i want this value as date in to the target and i tried as shown below but when i am trying to convert it to date i am getting the followin error " APT_CombinedOperatorController,3: Data string '20090304' do...

Thanks a lot guys and thanks for valuble suggestions It worked same as priyadarshikunal said in his reply here you go svZIP=Field(Trim(inputcolumn)," ",Dcount(Trim(inputcolumn)," ")) svState=Field(Trim(inputcolumn)," ",Dcount(Trim(inputcolumn)," ")-1) inputcol...

Thanks for all your help but , i have used Field(Trim(DSLink37.DDAM_SEASONAL_CITY_STATE_ZIP),' ',Dcount(DSLink37.DDAM_SEASONAL_CITY_STATE_ZIP)) this function toget zip but it is showing in RED Then i use Field(Trim(DSLink37.DDAM_SEASONAL_CITY_STATE_ZIP),' ',Dcount(DSLink37.DDAM_SEASONAL_CITY_STATE_Z...

Even i tried using Left and Right functions that posted earlier in the forum but still no use, i am getting different values.

Hi I have a requirement like below I have source data coming as Column A BOISE ID 11022 SUN VALLEY ID 12345 I need these single column value in to three different columns with City,State and ZIP columns. I tired with field function but if you see second record even city has space in between. Can you...

Hi All,

I am getting an error like
" Unable to save EditServ.impl.JobDefnImpl@10781078 "

while saving a job , can you guys please let me know what this issue is refering to ,

Thanks in Advance for your suggestions .

Thanks,

Kumar

ray.wurlod wrote:You can not use 8 or 9 in octal constants. ...

Hi Ray,

Thanks for your response and , can you please tell me what is this octal constant because i am not assigning any values like 8 or 9 in my logic and i am also getting compilation error with out that ocatl constant error.

Hi all, Can you guys please help me what exactly this error means and i am not able to figured it out the causing issue, please reply your valuble suggestions. Here is the Error Log , Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 16:40:16(000) <main_program> IBM WebSphere Data...

Thanks,

Thanks for the help and ,if i want process 15 million rows in three steps(5 million in each step) then how can i do it , can you help out me on this



Thanks

Kumar

Hi,

I have a big dataset coming in with 15 million rows, i have to process only 5 million rows , can you guys please help me how can i handle this situation

Thanks In advance


Kumar

B is also decimal the three fields iam using are decimals

Here is my cheking for denominator

If IsNull(a) Or IsNull(b) Or IsNull(c)
Then SetNull() Else If IsNotNull(a) And IsNotNull(b) And IsNotNull(c) And b<>0.0 Then
(a/b)*(c) Else SetNull()

Please help me out


thank you

Thank you for your response kumar_s the thing is when i am running my developement it is running fine and if i dont use stage varible its is giving lot of following errors Xfm_rate,1: APT_DecimalNumber::analyzeAndPrepare:divisor is 0. Xfm_rate,1: APT_DecimalNumber::APT_DecimalNumber: invalid decimal...

Hi , My job is getting failed in my preproduction run with full volume which job has succesfully ran with out any warnings in my job i am using a stage varible AKT decimal (10,4) the source column A for this variable is also having decimal(10,4) in stage varibale iam uisng NullToValue(A,0.0) It is n...

If (IsNull(a) Or IsNull(b) Or IsNull(c)) Then SetNull() Else If (IsNotNull(a) And IsNotNull(c)) And (IsNotNull(b) = 0000000000.0000 Or IsNotNull(b) = 0) Then (a* c) Else If (IsNotNull(a) And IsNotNull(b)And IsNotNull(c)) Then (a/ b) * (c) Else SetNull() Still iam getting same warnings i could't figu...