DSXchange

:!: Please don't post the same question multiple times, it just tends to upset the natives. If you wanted to change the Subject you used, edit your post rather than posting it again. Please delete your other post - you can do this as long as you do it before anyone replies to it. Edit: OK, never min...

One way - add a Sort stage and set Create Key Change Column to True. The new column will help you identify the duplicates.

How can anyone from what little you posted?

What exact version did you install?

You didn't need to repeat all that. Ray has already given you the beginning of your answer - read the file as one long varchar. Then substring out the first five characters so you know what to do with that record. So, absolutely no idea what the maximum number of occurances there could be? What's th...

kannan_ayyanar wrote:first i explain my prob in detail...

Would have been best to do that first.

That would be a "fixed-width" file, you need to let DataStage know that's what you have. Record Length = fixed, Quotes = none, Field Delimiter = none should get you closer. Make sure you set the field sizes properly so it knows how many characters to read for field. This is all noted in th...

If you are running on multiple nodes, try hash partitioning your input stream and lookup data, doing that properly will minimize the space it requires.

Further, an "aborted" Sequence will show a status of Aborted and if it is truly restartable - i.e. has checkpointing enabled - it will show Aborted/Restartable. No other status is restartable.

roy wrote:When working with Share point in my current location I can simply copy files to a shared folder over the network and that is all I need here.

If that's not enough information or you in fact need to do something other than that, let us know. Otherwise, it seems to me that should answer your question.

It's the default as that is the most common choice for that option.

(Although this is a very old post) Hey, it's not all that old... thanks for posting that. Sometimes people come and don't even check / notice the posting date and try to help with 5 or 6 year old issues. Or maybe they do and don't say anything. Sure, it can help future searchers but I imagine the o...

it is defined as time across all the stages... which is in time format 'hh:mi:ss' That's a string, not a Time datatype which is internal while yours is external. Depending on the target, you may need to use StringToTime() to properly convert it... which is exactly what the error you posted is telli...

If you literally mean 8.0, make sure you either have all of the "fixpacks" installed or you upgrade to the latest 8.1.x release. Many problems early on, perhaps you are seeing one.

I don't see how anyone could help from the extremely limited information you've posted. If you're certain your key values are "getting NULLed", have you verified where that is happening? Are they being sent to the DB fine and something happens there? Are they lost 'in job' somewhere and se...

Can you be more specific as to what exactly "the entire Datastage apps is going down" means?