DSXchange

They do provide pdf documentation for both the Row Splitter and the Row Merger stages, much like any PlugIn stage. Check in your 'Docs' directory under your Client install and you should find both there.

Excellent points. I tend to forget about the possibility of doing something after stage, the before/after job ones are so much more... visible. I should have mentioned the fact that you can land data and pick it back up again in the same job in the manner you illustrate. Heck, I just did something ...

Hmm... Craig, its not possible not to reject the rows as the volume is huge. So I will have to insert the dummy row somewhere in the "source" transformer itself. Not talking about rejecting any rows. You're not getting what I'm trying to say, let me see if I can rephrase it. I don't know all of the...

Not sure, but is the technique discussed in this post what you are thinking of? Or something you could use? If you mean simply concatenating all of those fields together to build a 'psuedo' composite key, just use the standard colon concatenation operator. Throw in the NullToSpace() transform to han...

Sometimes it also helps to build 'sub-sequences' that are run by the Master sequence job. That way jobs can run in logical 'groups' but if there are any issues in a sub-sequence, then it can write a message to its own log that causes the processing of any further sequences in the Master sequence to ...

Welcome! Off the top of my head, I know you can get the SQLERR from Oracle by referring to the DBMSCODE Output Link Variable in the Transformer handling the rejects. Not sure about the SQLERRM, but you could try some of the other Variables there and see if one might suit your needs. They are: LASTER...

I would think, if you've got a specific definition of 'first' in mind, the ony way to ensure that you get the one you want is to order the record set so that the one you want sorts out first. I wouldn't rely on the database unless you literally don't care which one you get at any given time.

For some reason I found this strangely amusing: If it works I'll explain why it works. If it doesn't work... ... Pay no attention to the man behind the curtain. I've filed away the tip about the 'string math' functions, didn't even know they existed. Thanks Ray. Curious if this works for you Roy.

Sorry, for some silly reason I missed the 'single column' statement.

If you do decide to go the UNIX route and pre-sort the file, take the extra step and add the -u to the sort command. Sorted and "de-duped" all in one swell foop. Keep the Stage Variables in the wings for the next problem.

Define 'duplicates'. They share a common key, certain data fields are equal, all fields are equal? The answer could change the approach. Couple of thoughts... a) Why not leverage your operating system? UNIX can sort a sequential file and remove duplicates using the 'sort -u' command. You may need to...

Well I am open to try this out (I can do that on Monday only, when I get to the office) but I suppose that if I use the union to get that extra row in the dataset from the first table, the row would be rejected in the first lookup itself as the join has to be an inner join. Don't let it. You contro...

Ok, if your source is a Relational Database then here's what I've done in the past to generate this dummy row. Switch to Custom SQL and use a union to join one 'extra' row to your dataset - one that you can easily recognize and will sort last into your input steam. In Oracle I'd simply select a hard...

Sorry to see this is still a problem for you. I do have to disagree (to a small extent) with your 'required details' comment... if you had, I'm sure someone would have been able to provide a solution for you by now. DSR.MetaGeta(GET.TABLES)(SQLConnect('RECON','dssuser')): BCI Error: SQLSTATE=01000,C...

Glad to see you are making some progress. Reading the previous posts, I know the solution to this problem; i.e. adding a dummy last row to the source, but the problem is how do I do that as my source is a transformer and so is my target. I think you are going to need to expand on this just a little....

Only if you tell it to. It's simple enough to keep its current value by assigning it to itself. For example, with one called MyVariable, use something like this in its derivation to only increment it when certain conditions are met: If X Then MyVariable + 1 Else MyVariable That make sense? Stage Var...