DSXchange

Well... it doesn't really seem to be something that's needed as those bare commas should process just fine. However, assuming the value is NULL in your source (from your subject) have you tried using the NullToEmpty() function?

Not via the NUM function, you would need to explicitly check your valid values or valid range instead.

On the search issue, for some reason only the "exact match" option searches the entire database. Any other search is secretly time limited to the most recent 60 (90? something) days, from what I recall.

Have you engaged your official support provider yet?

I'm going to assume, based on nothing but experience with other tools that did this, is that your 0 return code simply means the command was syntactically correct and thus ran without blowing up. Did you try passing it invalid syntax? Guessing you'll only see your non-zero return code then. And in t...

Welcome.

We will probably need more specifics to be able to help but let's start with this... what is your target? A database, Oracle perhaps?

Are you sure everything isn't there? It could be all there as "one long record".

Didn't notice that, good point.

Make sure you did not select 'use trigger column' from the Transformation Settings tab as that will cause the behavior you are seeing. And you don't specify an XML "prefix" but rather the full output path / filename. See if this helps, specifically Step 5.

Sounds like a job for a 'regular expression', something the Filter stage supports as one example.

I'm sorry but those multiple choice "which statement is TRUE?" questions look far too much like interview questions and we're not here to hand out answers to those. I've saved them and can put them back for all to see if you can convince me of your need for this information.

Thanks.

Welcome.

That is a horizontal pivot of columns to rows and there is a Pivot stage to help with that. The only extra thing you would need to do is add three columns before you do that, hard-coded to have your three PRODUCT_TYPE values, so they can be pivoted as well.

They may not be able to provide physical files. Can you expand on this a bit? They are generally delivered as physical files, are you looking at some kind of streaming or real-time source? And yes, you can process either out of the box with DataStage but it will be a rocky road without any knowledg...

Now if this is new behavior in the Connector stages, I'll have to defer to others.