DSXchange

Arnd, Even in sequential mode Dataset, shouldn't be quicker than the Sequential file, atleast theoretically? Dataset will be written in native format and not necessary to convert into Ascii. splayer, more over recording benchmark for data worth of processing within few seconds will not give out exac...

Varchar(50) is capable of holding the given data.
You may need to check the data is been truncated, particularly last digit during transformation.
You need to explain more of your job design and the method of load.

First available record in the lookup table's records set will be passed to the output along with incomming record set, if no lookup key is specified.
Else the matched row is processed among the existing record set. In your case, the available only row is the next sequence number.

user 'Synchronise Columns' Option available in Query tab.

Though the combinable option is enabled, its not guaranteed that the operators will be combined. Unless Dump score is overviewed. And more over this option will not affect the order of the row processing across nodes.

Query in Sparse lookup will be executed every time when each row enters the stage. And hence you get the new sequence number generated.
Increment of the sequence number is the job of Database not Datastage.

Date in Oracle has timestamp portion in it. Where as Datastage dosen't have one. Hence the Data data type is mapped to timestamp data type in datastage, with to_char() during select and to_date() to perform the vice versa during insert.

As Ray mentioned, if you got your problem solved, drop a word on how you manage to do it. So that it helps the other searchers.

If input data has empty spaces, the trim function will trim it and produce null. Based on the padchar property that was set in project level.
If the table columns are not null, the data will not be inserted.

What is the stage that been used?
Constraints need to be disabled for Oracle Bulk Load to function. In Oracle Enterprise stage you have an Option called "Disable Constraints" which can be set to true or false. But still, you exact question need to be understood.

Your server might be busy with other stuff when you are testing with dataset and might be comparatively idle when you process sequential file. This will make your dataset preparation to run slower. You can measure the CPU usage on both the cases.

Or the code provided by Ray. Open "DS_JOBS" To DSJobs.fvar Then ClearSelect 9 SSelect DSJobs.fvar To 9 Loop While ReadNext JobName From 9 If JobName Matches "1A0X" Then ReadV JobNumber From DSJobs.fvar, JobName, 5 Then LogName = "RT_LOG" : JobNumber Open LogName To Log....

Or you can tweak and use Kim's code for this purpose.

Setting up the auto purge option in the director will be the best approach. If CLEAR.FILE option is used, it will remove the autopurge property.
Also clear the %PH% directory regularly. Delete the orphaned jobs.

Yes, as Craing asserted, not atleast in the same job. One Job/ExecuteCommand Activity to read the field in the file and pass it as parameter for filename to the job which creates the file.