DSXchange

Hi, I have designed the Job in server before getting the I/P file name as the O/P file name using shell scripts. Now I would like to re-dsign without using the shellscipts. My design is :( I am just testing i donot whether its going to work or not) External source stage -----> xml I/P-------->Xfm --...

WHY use Execute Command activity to invoke dsjob command ?!!!!! Use a Job activity. You can then use "reset if required, then run" as its mode of operation, and everything is automatic. No ... I was using Execute command instead of Job activity because I need to process mutiple files and ...

The error messages look odd. What options are you using when calling the job from the sequence? Have you thought about using the "reset then run@ option so you don't need to explicitly reset the jo ... My Job design is from the execute command stage using the dsjob command I am calling the dsj...

What is causing the abort in the sequence that tries to reset your failed job? Could you post the error message that is generated? sequencer log: JobControl (fatal error from @Coordinator): Sequence job will abort due to previous unrecoverable errors dsjob log: Attempting to Cleanup after ABORT rai...

Hi, I am trying to reset my Job if the Input XML file is in incorrect format and not processed properly and nothing is loaded into the target DB then i am moving those files to unprocess folder where I am using a shell script to move the files from inbox to unprocess directories. I am using a routin...

My source is XML file and I am doing lookup to pull the ID joining the creation date but I need to get the max(ID) and when I am trying to use this User-defined query from RDMS stage its not working.................. SELECT Max(schema.tblname.DocumentID),schema.tblname.Created FROM schema.tblname WH...

i am working another deisgn again dates probelm. :shock: Sql server dates into orcale both are timestamps in source and target and I chnaged the sql types of source columns and given as varchar and able to view he data . In the transform used the stringtotimestamp function for conversion error: Conv...

us1aslam1us wrote:Good for you. But why SUM? Is that in your requirement.

yes, they wasnt sum of invoice quantity for the same invoices

Its still throwing me the same error.

Thanks,

chulett wrote:You really want to suggest they CAST the INVOICE_QUANTITY to a date? ...

Invoice_quantity is not date column .

I tried using like this in the sql....
sum(cast(inv.invoice_quantity,decimal) invoice_quantity

Let me know if I am on the right path

Thanks,

NOW ATLAST DATES ARE WORKING FINE .
I USED CONVERT FUNCTOIN AND IT WORKED

Thanks for all your help ......................................

us1aslam1us wrote:Try to use cast function and read that as a varchar.

For invoice date column its varchar in source and target . I would like to change just the format 04/13/2007 to 04-13-2007.


Thanks,

[2. Change AMOUNT field as decimal(38,10) both in source and target.
[/quote]

If I give decimal(38,10) for the source column it giving me as
00000000000.00

Thanks

Thanks for all your inputs. I will try them and get back to you......................

1)As wht dsguru said I increased the INVOICE_QUANTITY column length to 17 Source sample data :" 000000000007601" source sql type is Varchar(15) ----- Xml Varchar(17) Error1:INVOICE_QUANTITY floating point decimal is not fully supported; adjusting the scale. Error2:When checking operator: W...

Not all conversions are automatic as in server jobs. Your mindset is still on server jobs - you even marked this as a server jobs. The error message codes indicate that it isn't. You need expli ... No, I am not designing this Job in server its a PX job. I tried with the above results still while co...