DSXchange

Hi, I searched on "concatenate", found this link: http://www.dsxchange.com/viewtopic.php?t=125140&highlight=concatenate This hit specifically said to physically concatenate the files external to DS before processing. However, is it possible to logically concatenate sequential files wit...

SETFILE is in the UniVerse doc set. Hmmm, the questions just keep coming :wink: 1. Here is the list of locally installed doc on my machine: C:\Program Files\Ascential\DataStage7.5.1\Docs>dir Directory of C:\Program Files\Ascential\DataStage7.5.1\Docs 23-Dec-04 10:28 1,669,527 advpx.pdf 23-Jun-04 12...

So I did a PDF search as follows: Acrobat Reader Search all PDF documents in C:\Program Files\Ascential\DataStage7.5.1\Docs (53 documents in total) "SETFILE" Not one single hit. DS Designer and Administrator help files. Not one single hit. Yes a search of DSXchange on SETFILE returns 194 h...

Now, you can create a hashed file wherever you like and then create a VOC pointer in the project to that location and reference it by that pointer name in the UV stage. Sorry I don't know how to do that. I searched the doc set on "VOC" and got a lot of hits. It looks like the Basic Guide ...

Thanks Ray and Craig. I hit the doc, saw "localuv", success. Question: can I specify where the hashed file gets written? We like to keep all our hashed files in one spot for file system cleanup, etc. I tried #$HashFileLocation#/#DSJobname#_#DSStageName# for the table name, but no joy: Scot...

I think I've made progress on this topic... I've created a simplified job to test my approach. When I had DS create the container, it looked something like: Source DRS --> xfm --> Target DRS ==> Output where ==> is a reference link (dotted line) This setup allowed the job to compile. Now my question...

"Outer" job: DRS source --> xfm with hashed files for reference links --> DRS target One of the reference links is the container Container: DRS source --> xfm with hashed files for reference links --> Output stage (container box, blue arrow going out) I assume when I drag a container stage...

Glossary: NK = Natural Key SK = Surrogate Key Job design: Source Table containing NKs --> xfm with a bunch of reference links --> Target Table containing mix of NKs and SKs One of the reference inputs is a hashed file containing nothing but SKs. So, I have to do another "bunch of reference inpu...

Can I do select distinct <composite key> on the Universe table?

Job Design: Seq File --> xfm1 --> SQL Server #Temp table --> select distinct --> xmf2 --> SQL Server final table I need to do a bunch of lookups in xfm1, where the lookups will map source data to different values (example effective date to month surrogate key). I then need to write the distinct rows...

I'm experimenting with the sequential stage filter command... I've discovered I can do something like: File name: /dev/null (It seems DS requires a file name for the filter command, although I don't see why it should. What if my filter command doesn't require a file?) Filter command: head -5 /tmp/de...

You could split the job logically as follows: 1) GetParameters (read your metadata to get your parameters) 2) UseParameters (your current "downstream" job) Then call both jobs within a sequencer job. 1) would read your table, set UserStatus based on your table data, the job sequencer would...

You could split the job logically as follows: 1) GetParameters (read your metadata to get your parameters) 2) UseParameters (your current "downstream" job) Then call both jobs within a sequencer job. 1) would read your table, set UserStatus based on your table data, the job sequencer would...

(Scroll to the end for a summary...) Hi Craig, OK, I've got a DS server job as follows: SeqFile --> Extract (link) --> xfm --> Load (link) --> DRS Stage (MS SQL Server) The SeqFile contains two rows: 2009-09-30 2009-09-30 12:34:56 The column is defined varchar (doesn't really matter for a seq file a...

Hi Ernie, Thanks for all your replies. Much and genuinely appreciated. I'm neither an XML nor RSS guru (I've played with it some), and this appears to be falling into the too hard basket. So, things I've tried: * opened a local copy of the RSS XML file in Eclipse (I suspect any XML-aware editor woul...