DSXchange

If you try and set it in a transformer or in a parallel job then you will have some small overhead for every row of data you process. For example if you read it from a file in a lookup stage and assign it to a column of data then you have to pass every row of data through that lookup stage. The most...

If you are using an early 7.x release your key lookup column and your stream columns need to have exactly the same name before you can select them for a lookup key field. If you are using 7.5.1 then a normal lookup stage will let you drag and drop the stream field to the lookup key field. With 200 m...

The DB2 Enterprise stage is the way to go if you can work out how to configure those remote connections. Much faster in reading and writing. If you have effective DB2 table partitioning you can get some huge performance improvements over the API stage.

Do a view data on the source and lookup tables and copy and paste key fields to notepad, look for extra padding or funny characters as these can prevent lookups from working.

There is no harm switching job monitoring at the project level since you can always switch it back. If you lookup SIGILL or SIGSEGV you will see there are quite a few causes of this error and you will may have to use trial and error to see which one is affecting your jobs.

There is certainly a support training requirement, if a sequence job is at the status aborted/restartable then simply starting it will run from the failed checkpoint while resetting it will clear checkpoints. Support staff need to know when to run and when to reset. Simply starting a top level seque...

Call me crazy but isn't it easier and a whole lost faster to take BILL_DATE and derive the fields FIN_YEAR and FIN_MONTH instead of looking them up? It should be a relatively easy formula. If that is not viable then why not map every FIN_YEAR and FIN_MONTH combination to a calendar year and calendar...

It might be error SQL0301 which is input host variable or argument not valid. This would indicate one of the two join key fields is not valid. Can you do a "View Data" on the source, this should run the query without the filter, if the view data works then the error is in one of your two join fields...

If you are using the latest version (7.5.1) you can use the automated checkpoint restart built into sequence jobs. Go to job properties and look at the check boxes on the first properties screen. When a job aborts you will see it has the status of aborted/restartable, this means you can restart it a...

Bulk loads errors can be harder to find, you need to parse through the bulk load statistics file and find specific error codes. There is no differentiation in the bulk load log files between information messages and error messages, they look the same and have the same format. No bulk load errors tur...

From memory if you define the key columns on the input and output links of the row merger stage it wont concatenate them. It treats them as pass through columns and concatenates those columns that are not on the output tab.

Roy! Could you wave your magic wand at Jim and make him a FAQ Genie? His vertical pivot answer beats the FAQ out of the previous responses for completeness.

You can assign numbers in the transformer stage using the FAQ on How do I set up a counter in a parallel transformer? You just need to sort and partition on that number field and only increment the parallel counter when the key number field changes. You can do this with a lastkey stage variable for ...

Can you set your server machine date back a few days, update the license key and then move the date forward again?

As the funnellman says the problem is in the lookup. Your stream may define a column as not null and your lookup may define a reference fields as not null but if you have a lookup stage with failed lookup set to Continue you can end up with null values in the output field. You need to make the outpu...