DSXchange

I would think that you could tell it that your fields are not quoted so they come in as data and then you can trim off only the leading/trailing quotes.

IMHO you would be better off sticking to a file comparison utility for something like that, I use UltraCompare for example. For DataStage, you would have to individually compare all fields after joining on record numer in order to find those differences since you want to know what changed rather tha...

It's important to understand the topology here. All selects from sources are brought into the DataStage engine where transformations occur before being pushed to the target. So if each of those components are on different servers you could have a lot of information flying across the network that you...

That is your actual target here?

ray.wurlod wrote:In parallel jobs (in any version) data types are strictly enforced

Emphasis mine.

1. No to the "do we have to use" question
2. No to the "as soon as" question

Getting #1 working will get you #2. However, you may still find that your current design is faster.

"xsllt project"? Google is telling me that's a typo, so assuming you just meant "xslt project", yes?

Horizontal Pivot. You'll need to parse the data into individual columns first, the Column Import stage can do that for you.

Faye wrote:see the log file for the Oracle specific message.

... and the message is?

Bongo51 wrote:Do i have to start the service manually?

Did you try? What happened?

Please. Start your own post. Explain your problem.

Or a ulimit issue... it's one or the other but more than likely you just ran out of space.

True dat.

As noted, "May 12 2003 12:19:52:256" would typically be displayed like so: "May 12 2003 12:19:52.256" hence the "%ss.3" advice. But regardless, they need to match.

That's... a LOT of parameters.

So the subsequences don't leverage a large number of parameters as well? Seems odd to me that only the Master would be affected by this but perhaps carrying all of them puts it over some mystical pain threshold that it just can't handle.