DSXchange

It is in the delimiter property.

Was it working fine before (maybe with different version of oracle)?

Have you checked the PX installation steps for Oracle?

2/3 returns recurring decimal. So not possible to find exact value.

Search for round_inf.

Can you provide more information on what you are trying to view and what message you get.

That is a SAP module to be installed on SAP side.

Did you search for the name?

That is a SAP module to be installed on SAP side.

Did you search for the name?

Set the autoTransfer and autoWrite to false.

What are a and b? They do not have any relation to your data fields.

Why do you do a dropRecord()?

Use same input and output port names as declared in the interfaces.

I will suggest removing your code and make it working by default setting alone.

Does the link sort appear in the mentioned job or another job before this?

Try splitting the jobs into smaller jobs.

What is your scratch capacity, what OS?

Does the source Datasets directly landed from any database?

Search for "handling null" or your message without the field name.

There are loads of identical posts.

Do a NullToEmpty

Do a NullToEmpty

What if you provide the files in reverse order?

It will be useful to isolate the input seq file (with pattern) and an output (peek or seq file).

Do you perform any other activity other than file pattern?

What if you run outside datastage but from DS server?

How important is / are the missing rows?

ETL is expected to finish its activity in full and successful.

What tablespace is it running out of? Data or undo or temp (or rollback) or any other?

Does the total row count differ?

What if you write to a sequential file and then match them back to source?