DSXchange

Find out who deleted these files and castigate them severely. Then go to server backups - you have no choice.

Install .NET Framework 4.0 before beginning installation of Information Server components.

You have no concatenation operators within your CONVERT() function. You need them.

No single process will do that. For table definitions you need to manage shared table definitions. Other design-time objects will be placed there automatically as a result of final save. Operational metadata need to be collected and loaded with a specific command RunImportStart.sh (or RunImportStart...

You're going to need to sort the data (a requirement for the Difference stage), so you will need to name at least the sort key columns.

Use Aggregator and specify Max rather than Count.

In a 32-bit operating system without large file support, the segment file size limit for Data Sets is, indeed, 2GB per file. When this is reached, a new segment file is opened. These segment files can be viewed in the Data Set Management utility. The naming convention for segment files allows up to ...

There is no Final Delimiter property in server job.

dsusersaj wrote:The new line at the end of the line can be handled by the propery 'Final Delimiter' in the format tab. Did you try that?

Windows Server
Linux (Red Hat or SuSE)
AIX
HP-UX
Solaris
Linux on mainframe (zSeries)

You could have discovered these yourself by looking at IBM website.

Decimal(8,7) has only one digit to the left of the decimal placeholder, and seven to the right of it. You need a larger precision (at least four more than the scale figure). You probably don't need scale of 7, since your multiplier only has two decimal places. So maybe Decimal(8,2) would suffice.

It's still two at a time. Consider how difficult reporting from more than two would be.

Are these two jobs compiled successfully in production?

There are more reasons to fail an update than the row does not exist. It is only row not existing that will trigger an insert.

As a world-wide problem it would be mega-ugly. You can probably get close with a zipcode-timezone map, or maybe a zip3-timezone map. (Zip3 is first three digits of zipcode.)

Have you tried initiating the comparison from PROD?