DSXchange

Welcome aboard.

Make sure the "Lookup Failed" rule is correctly set in the Lookup stage.

Yes, it is possible.

There's no delete capability in a Hashed File stage, and update is actually destructive overwrite. Also this approach would not get your data into Oracle in any case. You could, however, write to three sequential files, then use subsequent jobs to get the data from these into (or out of) the Oracle ...

Try using VarChar(150) in DataStage.

Welcome aboard.

In Web Console for Information Server you need to set up DataStage User role for this user. You will also need to set up an appropriate role in each project using the DataStage Administrator client.

For how many concurrent users is your DataStage Designer client licensed?

It's not possible.

Read the Chapter in the Information Server Administration manual about backing up Information Server, which includes the metadata repository database as well as the software.

Do it again with RCP enabled and with OSH_PRINT_SCHEMAS enabled. Import the schema into the job design.

This language first appeared in the 1960s, when a four byte integer was a HUGE number. Most of the numeric functions expect four byte integers. Another example is the bit functions, like BITAND(), BITOR() and BITXOR().

A Data Set can have 10000 segment files per node over up to 1000 nodes, using default file naming conventions. Even with 2GB file size limits, this is twenty million Gigabytes. Do you really have more data than this?

Convert the date to a string. Subtract 1 from the year. Subtract 1 from the day if the date is 02-29. Convert the string into a date. Make sure that the year is not 0001, which requires special handling.

Try using Runtime Column Propagation and look at what DataStage produces. You should be seeing records containing subrecords made up of the input records (which explains the braces). You have to be particularly careful of nullable fields.

Not sure whether this is a parallel job or a server job. You marked it as a parallel job but posted it in the server job forum. Server Job Answer Oconv(InLink.TheDate, "DWA") for week day name, Oconv(InLink.TheDate, "DWB") for week day name abbreviation. Parallel Job Answers Week...