DSXchange

I'll make a full outer join (in order to get the old data too) and then via the transformer stage I'll make a split into the two tables. It's not so nice that I have to work with so much data then because I only need the ID, but will work...

Okay, or not okay... then I'll have to work with an outer join. Will also be an acceptable way.
Thank you

Hello, in my parallel job I have the following situation: after building checksums and comparing them, I have to do an update and to write the concerned old values in a separate table (before SQL statement). Therefore I need the concerned IDs from the link/stage before. But how can I reach them? cur...

Thank you guys for that quick help, I really tried a lot before writing in this forum and I'm fascinated about your quick and good answers.

I can just see your entry till "Code: Oconv(@DATE,"

I gues you mean Oconv(@DATE, "DYMD[4,2,2]"):" ":Oconv(@Time,"MTS"). Is that correct?

Sorry, you are right, I formulated it quite bad. I'll try it again: I have multiple parallel jobs and one sequence job. All parallel jobs have to have the same LOADID (which is the timestamp of the begin of the loading process). So what I tried to do after some googling and your suggestions: I defin...

Never heard of macros in DS before in my courses. After some googling this sounds to be what I'm looking for. So I tried to define a variable with this macro in the properties of job activity (in order to overhand this macro to all the parallel jobs). I tried it with #DSJobStartTime#, didn't work. D...

Hi DataStagers, I have to create a LOADID in DataStage which is the timestamp of starting the job. This LOADID has to be set in all the concerned target tables and should be the same within this job. Therefore I created a sequence job and tried to work with global variables. Currently the value of t...

Thanks chulett for that quick response. I'll let you know if I come up with a solution/workaround.

Hello, after installing the InfoSphere package InfoSvr_v8.7_Wdws_64 we got the following entries in the installation log file: Configuring client/server map file... Client encoding WIN:1252 => Map MS1252-CS MS1252-CS required and not currently installed Building MS1252-CS... ERROR: Error setting cli...