DSXchange

Interesting... thanks for posting that.

So... only in this one job or any job with a Sort stage?

They're not going to detail the differences between the new and old certifications, but you can get information on the latest version here.

Exactly - that's what they're being paid for.

That sounds like something you should be using RCP for, not parameterized DML. How are you defining the target columns in the stage? The bind variables would have to match up to the columns defined in the DML and the stage. RCP and schema files seems to me to be the proper choice here from what you'...

So... are you implying that there will always be four output files or will the number be a bit more dynamic?

So... the connector is being used as a source and you are passing in the entire SELECT statement as a parameter? I'd be very curious as to the why of that but let's start with you posting the parameter value. We'll also need to know how well that lines up with the columns defined in the stage.

Involve your official support provider.

So... this is for CDC?

Just to play Devil's Advocate, that is pretty generic stuff - "you may want", "most likely spatial localization", etc. I think for you to get more cogent help, you would need to detail what it is you have actually been tasked with, rather than generalizations like that. I'd also ...

Can you expand on what you mean by "Transform and operate on read Geo-Localization data"? Seems to me that might help drive your answer. I also don't think you're going to find a version of DataStage that specifically adds support for that API. Instead, you'll need to determine how best to...

The "expression" needs to evaluate to true or false and when it evaluates to true the trigger "fires". Without validating the syntax you are using, cut the expression back to something more like this: Oconv(@DATE,'DW') = 2 See if that works more better for you. If you still have ...

As noted, a little unclear. Can you clarify - does this ever work and if so, when? Or does it always import zero records?

Thanks.

Just to double-check, this is truly a Server job leveraging the WebService Client stage?