DSXchange

Does anyone have an MD5 "Stage" for DataStage 11.5 or tips of how to create one?

Also, it would need to match the perl digest::md5 results?

I have solved the issue: Using a Transformer Stage, I created a Stage Variable to concatenate the columns I want together. This is based on the ClusterChangeKey set up by a sort stage just previous. The other key point was to use a LastRowInGroup() as a constraint on the output so that I only get 1 ...

I have tried using a sort/transformer but then realized that this will only create a single record.....I am interested in multiple records.....[also, I did not get the results I wanted but this is my error]

Here is my data
key seq field
1 1 f1
1 2 f2
1 3 f3
2 1 ff1
2 2 ff2

I want to get the following output

key field
1 f1,f2,f3
2 ff1,ff2

Looking for some assistance as to how to perform this in DataStage 11.5

I am attempting to install the QualityStage AVI component and I am confused by the instructions which state... Download and extract the reference data packages by following the instructions in the Downloading the product section of the download document. Then, copy the reference data packages to the...

To all I have resolved the problem. Turns out there are numerous libraries and files to be copied to the IIS server (as per the documentation) for configuring IIS to support hadoop. Having re-done that work, I can connect to the files...The name I was using was also incorrect. Now, I have file proce...

I am trying to connect my Datastage environment (job) to a Horton Works sandbox v2.5 (runs on Centos 7). I have both IIS 11.5 operating properly and the HDP environment is running fine. I have followed the installation instructions for setting up hadoop in IIS ... /etc/hosts is configured, copied li...