DSXchange

That normally happens when the client machine is running out of memory. Close some other windows and/or re-boot. In particular, it is NOT a problem on the server. You have sent your DataStage support people on a wild goose chase.

Data Elements are the place where you record the business metadata associated with a business term, such as Customer, Money, Telephone Number, and so on. Most developers up to version 7.5 have ignored Data Elements as they do not realize the importance of business metadata. With the availability of ...

Surely that's why the RMM stage exists?

Yes, N times on the same node. On each node, if more than one. Each reader process reads 1/Nth of the rows from the file. Multiple readers per node is a technique for applying more than one process to reading a sequential file (which has to be read sequentially). At the beginning the size of the fil...

Create a delimited list of dates in an upstream Routine, and use that as the driver for a List loop. Error handling has been omitted here for clarity. FUNCTION ListOfDates(StartDate,EndDate) intStartDate = Iconv(StartDate, "DYMD") intEndDate = Iconv(EndDate, "DYMD&...

Depending on your Oracle date picture, you may need "-" instead of "/".

Create your batch as a job sequence and use "Reset if required, then run" as the run method in each Job activity. That will do it for you. Optionally inspect the generated job control code, look for calls to DSPrepareJob() - this is how you would do it if you cut your own code. From the traditional ...

What you should do is lie about which columns are the keys. Here you want DataStage to generate a WHERE clause containing your key columns. So tell it that Src_Date is a key column and that Copy_Of_Src_Date (organize this how you will) is also a key column.

To perform a lookup you have to have something in your source table that you can use a key into the reference table - it does not appear that your design fulfils this criterion. I believe you are trying to accomplish two things - to generate a sequential key where FIRST_NAME and LAST_NAME both exist...

You need to know what every byte in the stream is. The advice from rparimi is sound, and you need to be able to handle what ever is in the file. If that means forcing "them" to supply validly quoted character strings, then that's what it will take.

You change the metadata you remove the linkage into the collection of sort keys. Delete the Data Set, then re-run the job that populates it, and all should be well.

It's one of the basic UNIX signals. Try man signal or man -k SIGSEGV command to learn more.

Why don't you want to use the MultiLoad stage?

Answered here

EE is perfectly fine on a sufficiently configured laptop. 2GB memory, very fast CPU, lots of disk (maybe even a flash disk to augment same).