DSXchange

Clarify - "two consequtive quotes" means a double-quote? Or only if you have two double-quotes in a row? Show us some sample after rows as well.

As Kunal guessed. That's all any of us could do with no actual error.

Kind of an old wife's tale, Ray.

Not sure about other databases, but they store identically in Oracle. If you read down into the comments, you'll see that Tom (as in Kyte) says he "never" uses CHAR, interestingly enough.

Post the full error.

No. Define the maximum possible and then filter out the empty ones post-pivot.

Do you have an xsd for this target? If so, then import the metadata from it and the Importer will automatically generate the proper XPath Expressions for you. If not... post what you are using now.

OK, that much I know, was looking for something more... specific, example wise.

Not sure why you're not getting that unless you've enabled the 'chunk' (off the top of my head) property or left off the leading slash. Perhaps it might help to post the XPath Expressions you are using?

Just to make sure we're all on the same page, can you post an example of your "root element", please?

Unless they're not duplicates but rather a series of values that need to be applied in order. Then you would use... a sparse lookup?

Yes. Specifically, you have the Trigger Column option which splits the file when the value there changes. It's up to you to make it change at the right time, in this case every X records. That's how we managed things with Google, picked a sufficiently small enough number that we knew it would 'neve...

ps. If you are 'performance tuning' Server jobs, knowing the gory details of hashed files can be pretty... fundamental... to that effort. FYI.

What I mean is you should be pre-creating the hashed file at the proper size based on the anticipated volume, much like any other database object. Otherwise, they start off life very small and then 'extend' like mad, which adds overhead and time to the process. Just like any other database object. :...

Exactly. Your questions are pretty common when starting off and are all related to loading Oracle data regardless of the tool being used. Talk to your DBA (or co-workers familiar with the subject) and see what they suggest. Then people here can help with the DataStage specific implementation details.

Or perhaps just "vertical pivot". In any case, that is indeed what you need to be doing is called.

Suggest you just try it and then let us know when you have specific questions or some kind of specific problem.