DSXchange

Is your data sorted properly?

Interesting. Makes sense, it's just that I had read the document I linked to and there was this passage in it to that point: The data is stored as a continuous string of characters, with a column separator (@AM system variable). Each column is positional in nature and relative to the columns precedi...

That's like asking what is the difference between the OCI stage and the Oracle client software. Same relationship.

ps. Welcome to the proper forum for this discussion.

Still not huge and yes, can still be efficient. :wink: I'll let others with more intimate knowledge of the inner workings of hashed files respond but they're not stored as 'dynamic arrays'. No idea who wrote this (Ken, perhaps?) and I take exception to their use of the word 'small' but since they do...

Since it seems we're talking about a lookup in the Server product, consider the two approaches you've listed. 1) Singleton trips across the network for every incoming row in the job to do a SQL select against your target table. Sure, an index 'helps' here but this is (IMHO) a viable solution only fo...

Sreenivasulu wrote:Looks like you are trying to train yourself using the forum. This is not why the forum has been made. This forum is to discuss problems while using datastage. Hope i am clear.

A little annoying, I agree, hopefully he won't go too overboard with the questions of this nature.

Ah, yes... "etl-tools.info", a bastion of accurate information.

Excellent, I had read this last night and was trying to think how to articulate the points Keith made in his last two paragraphs, now I don't need to. :wink: Since I have yet to use them, was also going to ask if the connectors were more 'Informatica-like' in that you can include all column metadata...

1) Unanswerable. Well, except in much the same fashion that Ray did.

2) Perhaps reading this would be helpful.

Scribd has the Orchestrate manuals, I do believe. For example, the Developer's Guide but I didn't look for any others.

In other words, two passes through the data.

You need to let us know exactly where and when you get this error message and if a job is involved, the design of the job.

Hey, isn't that what I said?

Check out the Trim() function.