DSXchange

Hi All I am having history data from client loaded into a hash file. I need to use this hash file and compare with source to get delta data. Since source is not having any date columns, so I merging all the columns from source as well as from the target and generating CRC values for both. Now my log...

Since you have no other way to identify the changes, you will have to do all the comparisons. No way around it. You might like to use the CRC32() function, so that there's only one comparison, but you have to apply it both to your new source data and to the corresponding row in the target, in both ...

Hi I am having history data loaded into a hash file. Now, I need to compare source data (oracle table) with this history file(hash file) and send the delta changes(csv file) to client on daily basis that they will use for further processing. My definition of delta changes over here is, only the chan...

Hi All, I am using "wait for file" activity in a loop and if this activity fails I am suppose to run a job. Functionality is running perfectly fine, but it is showing me a warning message in log that wait for file activity failed, which is okay for me. I want to suppress this warning messa...

Tried to implement what you want and OCONV(@DATE,"D_E") is working fine, also just try to compile your job called in sequencer and sequencer, also see getsysdate is string datatype in called job, it works fine. thnx sachin.. it was date type in calling job. Thanks for your help !! Hi sach...

sachin1 wrote:Tried to implement what you want and OCONV(@DATE,"D_E") is working fine, also just try to compile your job called in sequencer and sequencer, also see getsysdate is string datatype in called job, it works fine.

thnx sachin.. it was date type in calling job. Thanks for your help !!

Hi All, I am calling a job from sequencer. The job parameter derivation I am defining in sequencer job activity. In the job parameter I want to fetch sysdate in following format: dd_mm_yyyy the derivation which I am providing in job activity is OCONV(DATE(),"D_") But the sequencer is givin...