DSXchange

Why not check in and around line # 185 in RT_BP828/JOB.2064671994.DT.1485054590.TRANS6 to find out in which part of the Transformer code (and, indeed, in which Transformer stage) the error is being generated?

Assassinate the novelists?

Go to your Administrator client, open the project properties then choose the Schedule tab. Here you can specify the user to be used for scheduled jobs and, indeed, test it.

Note that this is available only where DataStage engine is on a Windows platform.

It's database. You proved that with write speed to sequential file.

Have you considered using bulk loader for your inserts?

Yes, but how have you configured the Merge stage?

The job was running fine earlier. But suddenly it is showing this error (SIGSEGV). What changed? "Nothing" is not the correct answer. But what changed may have been in DataStage, in Oracle, in machine configuration, in network configuration, in the volume of data being processed, and so on. You nee...

If the data are sorted so that each header and associated detail lines are adjacent (and on the same partition), you can do it in stage variables in a Transformer stage. You need to ability to detect the header rows, presumably using some characteristic of their structure. You preserve these in stag...

Agree. In that case something like (small_multiple_of_packet_size / row_size) ought to be close. Trial and error seems to be necessary (making sure that all other variabilities are reasonably controlled for), and it's not even a smooth curve - some experiments have indicated a multi-nodal curve, the...

abhilashnair wrote:Also I came to know it has a lot of bugs. Is it true?

What do you mean by "it"?

Welcome aboard.

Reset the job. If a message "from previous run..." is logged, please post any content of that.

Also please describe precisely how you have configured your Merge stage.

In all cases the same tsort operator is used. Input link sorting constrains you to all default settings. If that's all you need it's a way to avoid cluttering up your design. But the Sort stage gives additional choices, such as the ability to generate key change columns, the ability to perform sub-s...

I'd like to see the 21 detail lines from the first query.

The second query tells us that there's no job in the project.

To get some idea of whether your Repository is intact please execute the following queries in your project. SELECT "NAME" FMT '32L' FROM VOC WHERE "TYPE" = 'F' AND "NAME" LIKE 'DS%' AND "NAME" NOT LIKE 'DS_TEMP%' ORDER BY 1; SELECT EVAL "OCONV(@ID, 'M...

You might get your answer faster if you Search DSXchange. This question has been asked, and answered, previously.