DSXchange

Welcome aboard.

Thank you for posting an intellectual exercise in database design.

What assistance do you believe an ETL tool might bring?

Assuming that the data type is string, check that the "same" values don't have the same number of leading or trailing space characters.

How many rows and how large is each on the reference input?

A Data Set consists of multiple physical files. On that basis at the very least the answer is "no". There are no columns, so there are no column headings. The storage schema is in the control file, not in the data files. Therefore the answer is still "no". Data are in binary form...

Look in startServer.log to find out why the server could not start.

Not until you have checked all the things I mentioned, or had your Windows administrator do so.

*Topic relocated - Content Editor*

What are the properties involved here, particularly the Field Delimiter property?

dsjob -lognewest can be qualified by an event type.

Type in just dsjob -lognewest to get syntax summary.

DSXchange Learning Center offers a DVD DataStage Server to Parallel Transition that may be useful.

If you don't answer the questions how do you expect us to help?

Veterinarians charge a lot more than human doctors because they have to diagnose patients who can't answer their questions.

Yes you can. Or MOVE, which has a simpler syntax.

Nice one. I've seen that done on Windows and Linux using a flash memory stick. Even 16GB is reasonably cheap these days. Arnd has used one for scratch space in a parallel job!

Prove that you are actually receiving nulls in the second environment - maybe View Data on the Oracle stage and View Data on the hashed file.

Sometimes on Windows this is a timing issue; the services try to start before the DB2 instance* is ready. Re-starting Windows usually works in this case. Otherwise, start DB2 (from the icon in the status bar) then try to start the services (in the correct order). * I've assumed here that your reposi...