DSXchange

It is returning alphanumeric values. So, can we take it as MD5?

Hi,

Does anyone know what is the checksum algorithm used by the checksum stage in datastage?

I have done more testing and found this. Below is the job design: Source file --- > Transformer(Has a reference from hash and writes the sequence generated to the hash if the natural key from source value does not exist) and another output link to output file. The sequence generation logic is writte...

Hi I have migrated a server job from Datastage 7.5 version to 8.5 version which uses KeyMgtGetNextValue for generating key sequence values. I noticed that there were some missing key values (there was a jump in sequence) when used in 8.5 which did not happen in 7.5. Any idea why this can happen? Tha...

Well, is there a way where I can retain the new line character after each record?

Hi All,

I have a parallel job which reads from a fixed width file and sends data through MQ. I am using segmented message options. Because of this records are getting concatenated within each message.

Is there any way to resolve this?

Thanks,
Preeti

I am unable to use a sequential file for reading and writing. It is able to accept data as input but in output getting error like "The currently selected link is a reject output link.There are no properties that can be set for this type of link." The same error i am getting with dataset.I...

If you explain what you mean by "link" you would get a better answer. This type of functionality has been done often in the past - but there are many means of solving it. Usually you have a Job Sequence which calls a job that access the tables to get the appropriate parameter values. Thes...

Hi,

If you are using the same invocation id for the multiple instance jobs, then try changing the invocation id.

Thanks,
Preeti

Hi,

Are you using the same invocation id for all the multiple instance jobs?

Thanks
Preeti

Hi,

It might be something related to the "preserve partitioning" in Transformer. Try other options for it.

Thanks,
Preeti

Hi,

What is the datatype of the column? Also, did you check the log to see if there is any info message about why the records are getting rejected?

Thanks,
Preeti