DSXchange

Indubitably!

Pellucid, eh? Had to go look that one up.

Google. Wikipedia. Ralph Kimball books.

Why not just look this stuff up on your own? We're not really here to educate you on basic database or warehousing topics. Google is your friend. Or check Wikipedia.

A live example? 23478390662

The Sequential File stage has a 'Contains Terminators' option on the Columns tab that you'll need to scroll over to see. Setting it to 'Yes' for the columns where the terminator character is in the data will allow the stage to read the file correctly.

One possible solution would be to scroll your Sequential File stage's Column tab over to the left so you can see the 'hidden' goodies on the right-hand side. One is 'Contains terminators' and when set to yes for a particular column will allow you to read terminators in that column as data.

One suggestion would be to leverage the Sequential File stage to create them for you as documented in this FAQ posting.

The answer will depend on if they were created 'pathed' or in an account...

Any chance Windows Service Pack 2 was just installed on your pc? There is a patch available for that, if so.

First, though, I'd simply try reinstalling the client. It's painless and will fix any odd registration or ddl problems that may have cropped up.

Write to a hashed file keyed to 'name' with 'marks' as varchar data. Reference lookup to same hashed file - not cached. Lookup miss = write new record, lookup hit = append new mark (and pipe) to existing data.

Source from hashed file when complete...

So now suddenly we are giving PX solutions to Server problems?

Then it sounds like you'll need to write a custom routine and take an iterative approach.

Why are we quoting entire messages? Are people not aware there is a simple Reply button at the bottom of the post? If you really need to quote someone, at least only quote the specific parts you are replying to, trim out all the other noise. This isn't usenet or someplace where we may not have acce...

Can you please advise some tuning tips? I have already created index on the table on which view is created. Thanks. No, not really, other than extremely generic stuff. Include the topic in your conversation with your DBA. Run an explain plan. Look for Bad Things that would cause operations to spill...

Do you have something against Transformer stages? What happens in approach number one when you add two of them into the job stream?