DSXchange

We have received new hardware, and need to migrate our projects from the old to the new. That we can do. We would also like to move some persistent Data Sets. Is this possible by moving their segment files and then editing the ".ds" files in some way? (And, if so, what edit is required?) W...

So far we have been implenting Type 2 SCD with no duplicate natural keys in the source input. We now have a situation where there may be more than one occurrence of the same natural key (for example CustomerID) in the source data, and each such row needs to be loaded into the target table (for examp...

Everything is OK. There wasn't anything obvious in the deadlock daemon log file. I'm still stumped, but happy that the resolution was automatic, and I can use the -p option for quicker resolution (if I read the help dsdlockd -H correctly).

Thank you again for a perspicacious response!

Thank you for speedy reply. The deadlock daemon is running; I will wait 30 minutes before checking again.

How do you know all these things?!

I have just had this message today; version 7.5.1A on Linux. The message (exactly) is: ACCESS DENIED: Project currently locked. The project is currently locked by the Administrator. Try again later or see your Administrator. This even occurs when (as dsadm) I try to open the project Properties from ...

That's amazing!! Ten posts per day, every day (on average), for nearly four years. Congratulations!

A Sequential File with a rejects link delivers rows in raw format onto that rejects link if the row does not match the record schema on the output link of the stage. My question is, is it possible to convert that raw row into a string? The Modify stage documentation suggests that manual conversion t...

I have a doubt about incrementally loading a hashed file using the write cache. If I understand correctly, the write cache allows DataStage to write to random pages in memory, then flush those pages to disk in a sequential manner. My question is whether the in-memory pages overwrite the pages in the...

I have noticed that some posters have their location displayed, while others do not. Is there a reason for this? I have filled up my profile when I joined, but my location is not showing. Is there anyone else in Pakistan participating here? This forum is a wonderful resource. I am learning new thing...

Sometimes it is difficult for me to visit this site for some time then I am having no time to read hundreds of posts when finally I am able to return. Is there any way to keep records of "unread" posts (this is not the same thing as "new since last visit")? I am thinking this is ...