DSXchange

ssnegi wrote:Put three constraint links in transformer for 123,456,789...Then funnel them into one link with three records.

Why 3? I don't see anything that notes it will always / only be three, matter of fact the second set of data shows 4 occurrences.

You could have an Email Notification stage at the end of a custom trigger that 'fires' if any of the jobs fail. And then the simplest solution is to check the option that says something like "Include Job Status" in the email. It won't be all pretty like but it will list the jobs that ran a...

Take XML out of the picture, it isn't really relevant here. You have a stream of records coming in and a lookup to do and you only want to pass records through to the target where the lookup succeeds. That should help. Then the result can either be written out to a dataset as you show currently or u...

From what I recall, there isn't a direct option in the Server Sequential File stage like there is on the Parallel side to read files via a File Pattern. However, it can be handled via the Filter option. Any command line option that can deliver rows to standard out will feed the stage as if it was re...

What are your Business Requirements? Specifically wondering about the rules for the "Name" and "Total" field chopping up you seem to be doing but that's always a hard call to make when someone posts completely made up "example" data with no requirements. Right now it do...

Not unless you write one, as far as I know. If you really need to do this, I'd probably look into using it via a BASIC Transformer in a Server Shared Container. Or if there's no burning need for the driving job to be a PX job, create it as a Server job.

Hey, at least they didn't ask about Oracle 7 support.

And I was more going for "works" rather than "is supported"... agreed that this should be put in front of their support provider, see what they have to say.

What about the possibility of installing an Oracle 8 client on the DataStage server and leveraging that?

Awesome... two posts with the same content. Going to lock this one, please use the other in its place.

:!: Sorry, General Rant alert that's been building up again for some time now :!: Please do not come here and simply post input and output samples with no other information. Spell out your requirements in words so we don't have to puzzle them out from the (often) confusing, incomplete or made-up exa...

From what little I've read of it, it uses JSON as its interface to the BSON (and .Net?) back-end so I'd look into that. There's also a C# driver but you'd have to write your own interface using that from what I've read.

I'm assuming you mean the default fall-back "I have no idea what this icon really should be" icon that looks like an electrical plug going into a wall socket. Yes? As noted, we've seen it happen on low memory systems. However... is this only happening to you but other people on other clien...

Then as noted, sort the data and have the Sort stage add a Key Change column on "Col1". Then it's a simple matter of checking the value in the Key Change column and when it is a 1, set your counter to 1. When it is a 0, increment your counter by 1.

I agree with Andy.

Double-check your output example - right now it doesn't support the assertation that you need to "assign number to duplicate records". They're just numbered sequentially without any apparent regards to duplicates. And then let us know what you've tried so far.

Of course. Closing this topic out with a 'Work Around' status.