DSXchange

I understand the challenge, and can assure you that is a normal situation. This is where QS is a great tool to match records where there are not common keys, but as I mentioned you need a good SME for the knowledge about their data. The goal should be to define the standards, how you want the gold m...

There is not an out of the box standardization rule set for products or items, so I would: - Develop a custom rule set to standardize the products raw input data - Design matching specification with the help of the SME for the products (He will know more about the classification/taxonomy of.the prod...

....DataStage does not have a data type that match Oracle Number without precision and scale, in your case the scale is not present. DataStage will represent them as double to correctly indicates that this might be a floating point number

Read your file, add a transformer with 4 output links connected to your DB connector Set the first three links to INSERT NEW RECORDS ONLY, map the account from the file input column and hardcoded the account type for each of your account type "ABC", "DEF" and "GHI" and ...

Did you try the workbench purgeOMD command? This istool command allow you to purge the operational metadata by date range, number of record to keep, engine, etc. The id running the command would need to have metadata admin rights. Do you have IGC installed and Governance people using it in your site...

Hi Arvind_ds, Wondering if you get to resolved the issue? A lot of us could learn from this situation .... We have a similar environment with 11.5.0.1 and Oracle 11g for XMETA, and we are planning to apply Fix Patch 2 and migrating the schemas to Oracle 12 c soon, just to provide the new features on...

If the "Generate operational metadata" was enabled also at the job level you will need to disable it and recompile You could see exactly which jobs are generating metadata, the xml files are named after the DataStage jobs that generates the files, and by default are place in below director...

Recently I was evaluating the iCEDQ application for same purpose

https:/icedq.com

Check the environment variable APT_IMPORT_HANDLE_SHORT, that might be part of your solution

All values looks good according to best practices, except the GLTABSZ that is lower than the recommended, and that I would advice pointing UVSPOOL/UVTEMP to other file system rather than /tmp which is normally a share temp file system to all applications running on your server. How big is your /tmp?...

Looks like the value of GLTABSZ is a bit lower, 300 is like the minimum recommended for 11.x. The minimum combination suggested by the big blue is 300/300/299 and this are minimum values, dependent on your environment you might need increase them Maybe you would like to publish the rest of the param...

Do you have the default values in the uvconfig file? Could you publish the values that you set for RLTABSZ/GLTABSZ/MAXRLOCK?

Clients on Windows 10 were available at 11.5.0.1

The system requirements for Windows OS should have it... Look on the component column which determine if the specs is for server or client

If you are referring to the REST step in the hierarchical stage then that was not available at 9.x. This feature was introduce at 11.x

There are several blogs on it on IBM DeveloperWorks site

Regards

I would address the first issue...the stop happens because after the first error happens a signal is send to the rest of the processes to stop.... Search in this forum the message, it has been discussed several times "will partition despite the preserve-partitioning flag on the data set on inpu...