DSXchange

Not a new work file, but a new virtual Data Set (in memory).

Sample question on IBM's website- follow link to sample test.
Vincent McBurney's blogs about the process will fill in some gaps.

It takes both D columns, but the one from the second lookup overrides the one from the first. Put in a Copy stage or a Modify stage on one of the lookup links to change the column names so that they're all distinct.

While trolling through the internet I happened upon this article on a new way to handle Slowly Changing Dimensions (SCD) with SQL Server Integration Services. It's not related to "our" product suite, but someone here might be interested. At least in finding another SQL Server blog site! Some other S...

If you're using version 7.5, click on the second tool from the right in the toolbar to produce complete documentation, including a picture of the job sequence design.

Welcome aboard. :D The first thing to do is to post your question in the correct forum. This forum is so that you can tell the world how great (or bad) you believe this site (DSXchange) to be. The second thing you need to do is to get some training. The vendor (IBM) offers standard classes on which ...

More to the point, do you take any steps to synchronize SDKSequences with the table? A simple job can SELECT MAX(keycol)+1 FROM table and load this into the SDKSequences hashed file, giving the name of the sequence as the key value (a constant in a Transformer stage). The key management routines do ...

We use PS EPM 8.9, but we developed most of Ascential jobs by Oracle consultants. Be specific, we have one dimension table d_program_fdm, after running all dimension jobs, the max dimension sid for d_program_fdm is 1,000,124. but in SDKSequences file, d_program_fdm has value as 30. SDKSequences, be...

You might want to, but it can't be done, as was observed. In your case, you can have a second trigger from each job activity to handle reporting of the problem (use a custom trigger, Activity.$JobStatus <> DSJS.RUNOK).

The question, as I understand it, is how to pass the invocation ID from a multi-instance job sequence to the multi-instance jobs run from that job sequence. The short answer is that you have to discover the job sequence's invocation ID upstream of the Job activity. I suggest a Routine activity that ...

Walter, more likely, our dear webmaster, is the one to fix this. Looks like the message board software has gone somewhat agley.

That a driver is not supported by IBM doesn't mean you can't use it. That's the entire point of OPEN DataBase Connectivity. All you need to do is to have its library findable (LD_LIBRARY_PATH environment variable, set in the dsenv script) and edit the .odbc.ini file to refer to it. Use any of the ot...

What are your property settings for the (presumably) Oracle Enterprise stage?

Bummer. UtilityHashLookup does not work with pathed hashed files. You could readily adapt it, of course.

In the job properties of the job sequence there is a check box called something like "Enable Multi-Instance". With this checked, a run request will additionally prompt for an Invocation ID, which is a string that uniquely identifies this clone of the job from all the other clones. Provided no-one el...